K
Khalil Handal
Range $b$13:$b$164 is autofilerd in sheet1.
STDNames is a name range for $F$13:$F$164 and is in sheet1.
I am using data validation to select a certain name using In-cell dropdown
in sheet2 cell A3.
If I filtered for the value of 2 in range $B$13:$B$164, Is it possible to
see only the filtered names in cell A3 and not the whole list of names?
STDNames is a name range for $F$13:$F$164 and is in sheet1.
I am using data validation to select a certain name using In-cell dropdown
in sheet2 cell A3.
If I filtered for the value of 2 in range $B$13:$B$164, Is it possible to
see only the filtered names in cell A3 and not the whole list of names?