| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofiltered file
in an autofiltered filed, where some rows are hidden, how do i count the
number of rows that remain in a column? I don't want to have to copy to another worksheet, just looking for some function or trick to use on the filtered worksheet itself |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofiltered file
=SUBTOTAL(103,column of cells) -- like =SUBTOTAL(103,A1:A50) even if many
rows are hidden. this is a counta of VISIBLE cells. "jimmj1210" wrote in message ... in an autofiltered filed, where some rows are hidden, how do i count the number of rows that remain in a column? I don't want to have to copy to another worksheet, just looking for some function or trick to use on the filtered worksheet itself |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel file lost | Excel Discussion (Misc queries) | |||
| Copy File Automatically on Opening It | Excel Discussion (Misc queries) | |||
| Pasword protected Excel file encrypted, how do I read this file? | Excel Discussion (Misc queries) | |||
| Links picking up values from an older version of linked file | Links and Linking in Excel | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Linear Mode
