How can I find the unique values in a column , remove the dups, and leave the count in the next column?
Example:
A
A
A
B
B
B
B
C
C
gives:
A 3
B 4
C 2
I only know the manual SUBTOTAL method then copy values to a new worksheet,... - real ugly.
How can I find the unique values in a column , remove the dups, and leave the count in the next column?
Example:
A
A
A
B
B
B
B
C
C
gives:
A 3
B 4
C 2
I only know the manual SUBTOTAL method then copy values to a new worksheet,... - real ugly.
Create a pivot
Best and Easy
Shijesh Kumar
http://shijesh.wordpress.com/
Of course. I completely forgot about those. Too busy looking for VB script solution.
Can I run a pivot table from a macro?
Thanks
Yes you can run pivot table from macros..
But that required very rarly..
U can create a pivot and keep on adding or deleting or modifiyt the data and click on refresh pivot to refresh the data
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks