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

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

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:

--

Dave Peterson

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

(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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Dave Peterson" wrote:

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:

--

Dave Peterson

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

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.

Luke M wrote:

(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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"Dave Peterson" wrote:

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:

--

Dave Peterson


--

Dave Peterson