依赖下拉列表Excel - 唯一值 [英] Dependent Drop Down List Excel - Unique Values

问题描述

我需要连接三个数据列表并将其放入下拉列表中。所以我开始制作命名范围，获取所有的唯一值等。

I need to connect three lists of data and put them into drop down lists. So I started by making named ranges, getting all of the unique values and such.

本质上，我按照本网站上的说明：
http://www.get-digital-help.com/2010/07/ 17 / create-dependent-drop-down-lists-contained-unique-distinct-values-in-excel /

Essentially I followed the instructions on this website: http://www.get-digital-help.com/2010/07/17/create-dependent-drop-down-lists-containing-unique-distinct-values-in-excel/

在关注网站后，我放置这三个下拉都在同一行，一个细胞分开。然而，现在我需要在下一行中有相同的三个下拉顺序。当我尝试这样做时，第二行依赖于第一行的值。所以如果我选择与第二行不一样的初始值的初始值，它将无法正常工作。

After following the website, I placed these three drop downs all in the same row, one cell apart. HOWEVER, now I need to have the same three drop down sequence in the next row down. When I try to do this, the second row is dependent on the values of the first one. So if I pick an initial value for the first row that is not the same initial value as the second row it will not work correctly.

有没有人看到这个方法？

Does anyone see a way around this?

谢谢！

推荐答案

因此，您正在为第一行中的第一个下拉框创建一个唯一的列表。第一行中第二个下拉菜单的唯一列表取决于第一行中第一个下拉列表中显示的值。第二个列表查找您在第一行的第一个下拉列表中选择的值，并使用从第一个下拉列表中选取的每个实例的对应值填充自身。每次在第一行的第一个下拉列表中选择新值时，此列表将重新填充和更改。

As it is, you are creating a unique list for the first drop down box in the first row. The unique list for the second drop down in the first row is dependent upon the value present in your first drop down on the first row. The second list looks for the value you selected in the first drop down of the first row and populates itself with the corresponding values for every instance of the value you picked from the first drop down. This list repopulates and changes every time you select a new value in the first drop down of the first row.

创建第二行时，第二个下拉列表为从第一行的唯一列表中读取。根据您在第二行的第二个下拉列表中的第一个下拉列表中选择的值，没有唯一的列表。

When you are creating the second row, the second drop down is reading from the first row's unique list. There is no unique list based upon the value you have selected in the first drop down of the second row for the second drop down of your second row.

解决方法是为第二行的下拉列表创建新列表。

The workaround is to create new lists for the drop downs in the second row.

从您的链接：

 3.Type "=INDEX(product, MATCH(0, COUNTIF($B$1:B1, product)+(order<>Sheet1!**$D$2**), 0))" 

粗体是你的问题当您拖动此公式时，它将所有内容与Sheet1上的D2绑定。您将需要使用此公式创建另一个列表，但将$ D $ 2更改为$ D $ 3，或者该行的第一个下拉列表的单元格地址。

The bolded part is your problem. When you drag this formula, it ties everything to D2 on Sheet1. You will need to make another list using this formula, but change $D$2 to $D$3 or whatever the cell address of your first drop down is for that row.

这篇关于依赖下拉列表Excel - 唯一值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！