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.