| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i count amount of data in a filtered list?
once i filter the data in a given list, the row numbers change from
1,2,3,4,5...to 1, 100, 102, 188,700 etc because the data has been filtered. i want to know if there is a way to count the amount of rows data there are after i filter?? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i count amount of data in a filtered list?
Assuming that your data is from A2:A1000
=SUBTOTAL(3,A2:A1000) JTP wrote: once i filter the data in a given list, the row numbers change from 1,2,3,4,5...to 1, 100, 102, 188,700 etc because the data has been filtered. i want to know if there is a way to count the amount of rows data there are after i filter?? Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i count amount of data in a filtered list?
Have a look in the help index for SUBTOTAL
-- Don Guillett Microsoft MVP Excel SalesAid Software "JTP" wrote in message ... once i filter the data in a given list, the row numbers change from 1,2,3,4,5...to 1, 100, 102, 188,700 etc because the data has been filtered. i want to know if there is a way to count the amount of rows data there are after i filter?? Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i count amount of data in a filtered list?
i tried that, but my values are not numbers. when i am configuring hte
subtotals, i dont know if i shoukld use "count", "sum", "vald" etc to count up text values... "Don Guillett" wrote: Have a look in the help index for SUBTOTAL -- Don Guillett Microsoft MVP Excel SalesAid Software "JTP" wrote in message ... once i filter the data in a given list, the row numbers change from 1,2,3,4,5...to 1, 100, 102, 188,700 etc because the data has been filtered. i want to know if there is a way to count the amount of rows data there are after i filter?? Thanks! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i count amount of data in a filtered list?
=subtotal(3,range you want to count)
3 would be for countA 2 would be for count "JTP" wrote: i tried that, but my values are not numbers. when i am configuring hte subtotals, i dont know if i shoukld use "count", "sum", "vald" etc to count up text values... "Don Guillett" wrote: Have a look in the help index for SUBTOTAL -- Don Guillett Microsoft MVP Excel SalesAid Software "JTP" wrote in message ... once i filter the data in a given list, the row numbers change from 1,2,3,4,5...to 1, 100, 102, 188,700 etc because the data has been filtered. i want to know if there is a way to count the amount of rows data there are after i filter?? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I count items in a filtered list? | Excel Worksheet Functions | |||
| How do I count rows in a filtered list when using AutoFilter? | Excel Worksheet Functions | |||
| Using Count Function on Filtered List | Excel Discussion (Misc queries) | |||
| count filtered data | Excel Discussion (Misc queries) | |||
| count specific value with filtered data | Excel Worksheet Functions | |||
Linear Mode
