ExcelBanter - Using Excel's Auto Filter, how can I show # of records returned?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Using Excel's Auto Filter, how can I show # of records returned? (https://www.excelbanter.com/excel-worksheet-functions/77039-using-excels-auto-filter-how-can-i-show-records-returned.html)

Jim

Using Excel's Auto Filter, how can I show # of records returned?

Pleaes help

Arvi Laanemets

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

All times are GMT +1. The time now is 05:57 PM.