View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets
 
Posts: n/a
Default Using Excel's Auto Filter, how can I show # of records returned?

Hi

=SUBTOTAL(2,NumericRange)
,or
=SUBTOTAL(3,Range)
, where NumericRange or Range are single-column range, which include all
rows of table.

Arvi Laanemets


"Jim" wrote in message
...
Pleaes help