Hi all!
I have a table with 2 columns. I need a formula that would help me to do the following:
Count how many times each value on column B shows if value in column A is defined and sort it.
To make it easier to understand example:
1 AAA
2 AAA
3 BBB
4 CCC
1 BBB
2 CCC
3 AAA
1 BBB
1 BBB
2 BBB
1 CCC
1 AAA
So for value 1 it should give me something like this:
BBB 3
AAA 2
CCC 1
Hope I made it clear. Hope you guys can help. Sorry if this is dumb question
Bookmarks