Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting records in a filtered list
How can I count the number of records in a filtered list. The list gives me
the record number on the left so how can I count (other than manually) the number of records that exist in that list? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting records in a filtered list
Hi
=SUBTOTAL(3,A1:A100) -- Regards Frank Kabel Frankfurt, Germany plato wrote: How can I count the number of records in a filtered list. The list gives me the record number on the left so how can I count (other than manually) the number of records that exist in that list? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting records in a filtered list
To programmatically count the rows, you can use the code shown he
http://www.contextures.com/xlautofilter03.html#Count '==================== Sub CountVisRows() 'by Tom Ogilvy Dim rng As Range Set rng = ActiveSheet.AutoFilter.Range MsgBox rng.Columns(1). _ SpecialCells(xlVisible).Count - 1 _ & " of " & rng _ .Rows.Count - 1 & " Records" End Sub '=============================== plato wrote: Thanks Frank, Not sure how to use this. Do I put this formula in the cell below the last record (if there are say 1000 records)? thanks Paul "Frank Kabel" wrote in message ... Hi =SUBTOTAL(3,A1:A100) -- Regards Frank Kabel Frankfurt, Germany plato wrote: How can I count the number of records in a filtered list. The list gives me the record number on the left so how can I count (other than manually) the number of records that exist in that list? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select random sample of records in a filtered list | Excel Discussion (Misc queries) | |||
Counting the number of unique values in a filtered list | Excel Discussion (Misc queries) | |||
Counting unique text entries in a filtered list... | Excel Worksheet Functions | |||
Counting a Filtered List | Excel Discussion (Misc queries) | |||
how do I see more than 1000 records filtered | Excel Discussion (Misc queries) |