| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count Autofiltered Rows?
Here's a quick one:
Anyone know how I can get a cell to show the number of records displayed when autofiltering by column? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count Autofiltered Rows?
You dont need VBA, use subtotal it only examines visible cells...i.e,
use: =SUBTOTAL(2,A1:A9), with A1:A9 being the range of all possible cells...if you look at help you can see the other uses for subtotal (i.e. the 2 tells it count, but you can have subtotal do things like sum up the visible cells) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rogue rows appear in autofiltered sort | Excel Discussion (Misc queries) | |||
| How do I use count, sum, or avg formulas on autofiltered results. | Excel Worksheet Functions | |||
| Dynamic count on an Autofiltered list | Excel Discussion (Misc queries) | |||
| Count the number of AutoFiltered records | Excel Worksheet Functions | |||
| Copy Autofiltered rows to another workbook using macro | Excel Discussion (Misc queries) | |||
Linear Mode
