| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to link Auto Filter values to a Cell
a ha! thanks.
"Ardus Petus" wrote: Use Advanced filter instead HTH -- AP "SteveC" a écrit dans le message de news: ... Instead of going into each auto filter drop down box, I'd like to type a value in a cell and have auto filter link to that cell so I can easily filter along different criteria. Is this possible? More specifically: Column AM with about 3000 rows has % values 1-100%. I just want to return bottom 10%. Currently I have to go into auto filter and the custom value to less than .1. But going into the drop down box takes too long. Can I link auto filter to a cell where I can just type in ".1" and have it filter the entire column? Is this a macro question? I hope not. Thanks... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replacing Linked Cell Values w/ Current Values | Excel Worksheet Functions | |||
| AUTO COMPLETE FOR CELL VALUES | Excel Discussion (Misc queries) | |||
| Cell reference in the auto filter custom list | Excel Discussion (Misc queries) | |||
| Refreshing drop down cell values... | Excel Worksheet Functions | |||
| set hypothetical values for a cell | Excel Worksheet Functions | |||
Threaded Mode
