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

[David O.]

 

[Dave Peterson]

Make sure the statusbar is visible.

If you see "Filter Mode", then look at Debra Dalgleish's site:
http://contextures.com/xlautofilter02.html#Count



David O. wrote:

 

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

 

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