How do I view..."no. of records found"... when I filter.

  • Thread starter Thread starter David O.
  • Start date Start date
(Responding to OP)

An alternative to the finicky status bar is to use the formula:
=SUBTOTAL(3,A:A)-1
(assumes you have a 1 header row)

Also, please note that the body of a post should contain your question! The
subject line should only contain a few key words. Not only does the entire
subject line not always appear on a web page, but if you try to reply to a
blank message, an error occurs.
 
And it assumes that column A has data in it in the visible cells. And there's
nothing below the filtered range in column A.
 
Back
Top