Hi,
I would like to create a data filter (kind of combo box I think).
I want to have this data filter in cell D1 to show unique values (no duplicates) of what is in cell B2:B50000. Besides if I select a value in the filter, I would like to see all the rows associated with that value.
Basically it works exactly as an excel data filter, but it's located in D1 instead of B1.
Example
B2= james
B3=linda
B4=charles
B5=james
in D1 I would like to choose between james, linda, charles (no duplicates)
If I select james, the spreadsheet shows only rows 2 and 5
Is it possible?
Bookmarks