Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Trouble With Data Validation And Filtering On A Dropdown
Hi all,
I need help! I created a dropdown menu using Data Validation and a dynamic range, so that anything typed into the range automatically appears on the dropdown. The formula I used for this was a Defined Name of: =OFFSET('Priority List'!$C$6,1,0,COUNTA('Priority List'!$A:$A),1) Where C6 is the header cell of the column and I want the range to go on to the end. What I want to know is how I can filter that dropdown so that when I select "A" from the dropdown menu, all the rows that do not have "A" in the C-column are hidden (like what happens with Autofilter). Is there any way to do this? I am pretty new to the tough aspects of Excel, so please try to keep it relatively simple. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Filtering | Excel Discussion (Misc queries) | |||
Data Validation and Filtering | Excel Discussion (Misc queries) | |||
Filtering and Data Validation | Excel Discussion (Misc queries) | |||
Data Validation | Excel Discussion (Misc queries) |