build data validation list that filters a tables 1st column and displays the same tables 5th column

Question

I'm at wits end trying to create a drop down list from the selected rows of field "CardName" based on "ProcName".&nbsp; I'm using Excel 2016.&nbsp;&nbsp;

adlih · Answer

recho&nbsp;下拉列表需要在資料&gt; 資料驗證 &gt; 選擇 "清單" &gt; 選擇"範圍" 去製作

adlih · Answer

recho&nbsp;&nbsp;你的情況需要先在K欄創建算式去判斷該列是否合符你指定的"ProcName"條件如果合符 K欄出 "Y" , 不合符 K欄出 "N"然後在L欄創建算式去判斷如果 K欄 是" Y " ,&nbsp;L欄 = E欄,&nbsp; 否則&nbsp;L欄 = 空白然後將&nbsp;L欄範圍設置為 資料驗證的 清單範圍&nbsp;

recho · Answer

English please..&nbsp;adlih&nbsp;

Forum Discussion

build data validation list that filters a tables 1st column and displays the same tables 5th column

3 Replies

Resources