C
Claudia d'Amato
I have seen a couple of times Excelsheets where drop down filters exist in e.g. cell C2
for the range of cells from C3:C27.
So when in den cells C3:C27 value appear like
aaa
bbb
ccc
aaa
bbb
bbb
aaa
....
ccc
and I select the drop down menu in C2 then all available values should appear
when I select then "aaa" only those rows should remain which contain value "aaa".
How do I achieve such a row filtering?
Claudia
for the range of cells from C3:C27.
So when in den cells C3:C27 value appear like
aaa
bbb
ccc
aaa
bbb
bbb
aaa
....
ccc
and I select the drop down menu in C2 then all available values should appear
when I select then "aaa" only those rows should remain which contain value "aaa".
How do I achieve such a row filtering?
Claudia