Hello friends
I want to count the rows of my filtered table. can I do it using functions and formulas or I have to code VB using marcos ?
Let's say we have a table like below
1.png
I want to filter the table through column "name" by elements 'a' and 'b'. the result is like this
2.png
But I want the "row count" to start from 1 and end up to 3. ie.
3.png
please let me know what the solution will be like.
The SUBTOTAL function calculates on visible cells.
=SUBTOTAL(FuncNum,Range)Note: Adding 100 to any of those FuncNums causes the SUBTOTAL function to ignore HIDDEN rows, not just hidden FILTERED rows.Func Num__Function 1_________AVERAGE 2_________COUNT 3_________COUNTA 4_________MAX 5_________MIN 6_________PRODUCT 7_________STDEV 8_________STDEVP 9_________SUM 10________VAR 11________VARP
Example: =SUBTOTAL(103,A1:A20) counts non-blank, non-hidden cells.
Is that something you can work with?
Make D2:
=SUBTOTAL(103,$b$2:B2)
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Ron Coderre and daffodil11:
You guys helped me a lot
It worked !
thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks