Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I display chosen filter in a cell below
I filtered in excell a long list of rows and now I only see the rows filtered.
What function could I use below the data to automatically show the filtered criteria? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I display chosen filter in a cell below
"Fernando Seisdedos" wrote: I filtered in excell a long list of rows and now I only see the rows filtered. What function could I use below the data to automatically show the filtered criteria? I do not think this is possible with Auto Filter (someone please correct me if I am wrong), But is very easy to do using the advanced filter. The advanced filter option is located in the same menu as the Auto filter, but two options down. Let me know if you need any help using the advanced filter. Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Is there a way to link Auto Filter values to a Cell | Excel Worksheet Functions | |||
display a drop-down list based on the content of another cell | Excel Discussion (Misc queries) | |||
Display a row if a cell value is greater than zero | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |