Hello! I'm new to the thread and I am hoping someone can help with my specific problem or maybe point me in the right direction so I can learn how to solve.
For the example table:
Group Email
A x@y.com
B t@y.com
A d@y.com
A v@y.com
C m@y.com
I need to find all the unique "Groups" and provide a count for each Group. I can probably do this using the SUMIF function, but I think that will require some unnecessary work. There has to be a more efficient way. The table I'm working with has 100k records and up to 94 unique "groups".
Thanks for the help!
Last edited by dannyb0y; 08-30-2011 at 04:02 PM.
Easiest would be a pivot table (Insert tab> Pivot Table. Use Group in Row Labels and in Values (Count of Group).
Alternate, With Excel 2007, copy your group column to a new column and then delete duplicates
Data tab> Remove duplicates. Then do CountIF in the next column
Either of these work for you?
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Oh, right! I'm not entirely comfortable with pivot tables, but your second method should work very nicely.
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks