Thread: How do I count the number of records autofilter is showing in Exce
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How do I count the number of records autofilter is showing in Exce
=SUBTOTAL(2,A1:A100)
--
Gary''s Student - gsnu200908


"Patricia O''Donnell SSJ" wrote:

I want to have a count of the number of records that autofilter selects. That
number showed at the bottom of the screen when I first began using Excel (not
sure what version; before 2000 anyway), but now, it seems to have disappeared.
Reply With QuoteReply With Quote