Counting Text

[Jenny Orr]

Hi

This might be a simple question but I'm stumped & would appreciate some advice.

I have over 4000 rows of text data that will need multiple manipulations & filtering but require a running total of visible rows only.

This data is not in numerical format so subtotals & count formulas do not work.
Adding in an additional column of numerical digits to count does not show me where the text data has been manipulated & therefore the count would be wrong, unless I also manipulate this additional numerical column - unnecessary extra work.

So - I need to know how to count visible rows of various text string after manipulations.

Many Thanks

Jenny

 

[mole999]

have you looked at subtotal

 

[Rick Rothstein]

I have over 4000 rows of text data that will need multiple manipulations & filtering but require a running total of visible rows only.

This data is not in numerical format so subtotals & count formulas do not work.

Did you try applying the SUBTOTAL function to a single column (guaranteed to have data in each of its cells) using 103 (COUNTA) for the argument?

 

[Jenny Orr]

Did you try applying the SUBTOTAL function to a single column (guaranteed to have data in each of its cells) using 103 (COUNTA) for the argument?

Thats works - thanks!