| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count non-hidden rows
Is there a way to count non-hidden rows in a column?
-- Art |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count non-hidden rows
Look in the help index for SUBTOTAL and read the part about hidden non
-- Don Guillett Microsoft MVP Excel SalesAid Software "Art" wrote in message ... Is there a way to count non-hidden rows in a column? -- Art |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count non-hidden rows
Lots of ideas for counting he
http://www.contextures.com/xlFunctions04.html Good info here too: http://www.ozgrid.com/Excel/excel-subtotal-function.htm You need something like this: =SUBTOTAL(2,A1:A10) -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Don Guillett" wrote: Look in the help index for SUBTOTAL and read the part about hidden non -- Don Guillett Microsoft MVP Excel SalesAid Software "Art" wrote in message ... Is there a way to count non-hidden rows in a column? -- Art . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count non-hidden rows
Ryan; function_num 2 is to include hidden values. To ignore hidden values the
function_num is 102 =SUBTOTAL(102,A1:A100) -- Jacob "ryguy7272" wrote: Lots of ideas for counting he http://www.contextures.com/xlFunctions04.html Good info here too: http://www.ozgrid.com/Excel/excel-subtotal-function.htm You need something like this: =SUBTOTAL(2,A1:A10) -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Don Guillett" wrote: Look in the help index for SUBTOTAL and read the part about hidden non -- Don Guillett Microsoft MVP Excel SalesAid Software "Art" wrote in message ... Is there a way to count non-hidden rows in a column? -- Art . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count non-hidden rows
And I dont think the OP is looking for count() which gives the count of
numerics instead OP is looking for "count non-hidden rows in a column?" -- Jacob "Jacob Skaria" wrote: Ryan; function_num 2 is to include hidden values. To ignore hidden values the function_num is 102 =SUBTOTAL(102,A1:A100) -- Jacob "ryguy7272" wrote: Lots of ideas for counting he http://www.contextures.com/xlFunctions04.html Good info here too: http://www.ozgrid.com/Excel/excel-subtotal-function.htm You need something like this: =SUBTOTAL(2,A1:A10) -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Don Guillett" wrote: Look in the help index for SUBTOTAL and read the part about hidden non -- Don Guillett Microsoft MVP Excel SalesAid Software "Art" wrote in message ... Is there a way to count non-hidden rows in a column? -- Art . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count non-hidden rows
If you meant using VBA code, something like this should work...
Dim RangeToCount As String, VisibleRows As Long ..... ..... RangeToCount = "A1:A100" On Error Resume Next VisibleRows = Range(RangeToCount).SpecialCells(xlCellTypeVisible ).Count -- Rick (MVP - Excel) "Art" wrote in message ... Is there a way to count non-hidden rows in a column? -- Art |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hidden rows columns won't stay hidden | Excel Worksheet Functions | |||
| Counting rows in a spreadsheet, but I don't want to count hidden r | Excel Discussion (Misc queries) | |||
| Count number of rows, where non relevant rows are hidden | Excel Discussion (Misc queries) | |||
| I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
| Unique Count sensitive to hidden/filtered rows | Excel Worksheet Functions | |||
Hybrid Mode
