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?

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