Saurabh k

asked on

# Count number of rows populated by an autofilter in excel.

team subteam user priority

T t2 u1 1

T t2 u2 1

T t2 u2 1

T t2 u2 1

T t2 u1 1

T t2 u1 1

T t2 u2 1

T t2 u1 1

T t2 u1 1

T t2 u2 1

consider above data I get by applying an autofilter for priority 1 for users u1,u2 belonging to team 2, what I need is a count of the populated rows in column ''priority'' in Excel VBA code. I tried using Subtotal function but I don't want the count generated via subtotal function.

T t2 u1 1

T t2 u2 1

T t2 u2 1

T t2 u2 1

T t2 u1 1

T t2 u1 1

T t2 u2 1

T t2 u1 1

T t2 u1 1

T t2 u2 1

consider above data I get by applying an autofilter for priority 1 for users u1,u2 belonging to team 2, what I need is a count of the populated rows in column ''priority'' in Excel VBA code. I tried using Subtotal function but I don't want the count generated via subtotal function.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

I have recommended this question be closed as follows:

Split:

-- Rgonzo1971 (https:#a42399734)

-- aikimark (https:#a42401959)

-- Rob Henson (https:#a42399731)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

MacroShadow

Experts-Exchange Cleanup Volunteer