Thread: Counting records in a filtered list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default Counting records in a filtered list
Hi
=SUBTOTAL(3,A1:A100)

--
Regards
Frank Kabel
Frankfurt, Germany


plato wrote:
How can I count the number of records in a filtered list. The list
gives me the record number on the left so how can I count (other than
manually) the number of records that exist in that list?

Reply With QuoteReply With Quote