Sunday, 15 September 2013

Finding combinations and count in excel

Finding combinations and count in excel

I don't know much about excel and I'm trying to do the following. Any help
would be so appreciated.
So if a I had column A and column B:
A B
red green
red green
red green
blue pink
blue pink
blue pink
blue pink
black white
black white
Let's say I have hundreds of rows of combinations. What I need to do is on
a second sheet, show all the different combinations and the number of
times each occurs. So for the above, the result would be:
Combination: Number of times:
red green 3
blue pink 4
black white 2
So, I would need to give me the combination and the number of times it
occurs. Any idea how I could do this?

No comments:

Post a Comment