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

L

Luke M

(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.
 
D

Dave Peterson

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.
 
Top