| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
How to define a drop down row filter in cell C2 for cells C3:C27 ?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I transfer a filter drop down box to another cell? | Excel Discussion (Misc queries) | |||
| How to define a drop down row filter in cell C2 for cells C3:C27 ? | Excel Discussion (Misc queries) | |||
| Equating page filter value to a cell drop-down value | Excel Programming | |||
| How do I define "contains' as the default custom filter? | Excel Worksheet Functions | |||
| define cell for autofit of merged cells | Excel Programming | |||
Threaded Mode
