Auto Filter

[Guest]

I am using auto filter to get rid of columns where there is no infomration.
My problem is, that in another column I need it to just count 1, 2, 3, 4 etc.
once it is filtered. Does anyone know how to do this?

Thank You,

 

[Guest]

If you have Excel 2003 or 2007, then this formula should do the trick:

=SUBTOTAL(103,$B$2:B2)

Place in an empty column adjacent to your data, then copy down as needed.
Your column of data that this formula references (Col B in my example) must
not contain any blanks for this to work.

HTH,
Elkar