uaku
01-10-2012, 12:52 PM
Hi I have a large data on my excel spreadsheet. I use data>Filter>Auto Filter all the time.
Is it possible to count the number of rows after running auto filter on certain criteria. Here is the data
A B C D etc
Text1
Text2
Text3
etc
I use auto filer to show all the values for criteria meeting text1. How can I display a count on the top? When I change the criteria to "Text2" the count should change automatically.
Thanks for your help. I hope I managed to explain the problem well.
Is it possible to count the number of rows after running auto filter on certain criteria. Here is the data
A B C D etc
Text1
Text2
Text3
etc
I use auto filer to show all the values for criteria meeting text1. How can I display a count on the top? When I change the criteria to "Text2" the count should change automatically.
Thanks for your help. I hope I managed to explain the problem well.