Hello. Im gonna cut straight to the chase, i found this forum after hours of searching and needing help with something that supposedly is an easy peasy fix for excel savy people out here.
Problem: I need to count how many pairs from 2 cells appear.
This is my list of numbers:
B | C
1005 2488
1005 2488
1005 2488
1005 2488
1005 2488
1005 2488
1005 2488
1005 2488
1005 2488
1005 2488
1005 2488
1005 2488
1005 2488
1005 2488
1005 2488
1005 2489
1005 2489
1005 2489
1005 2489
1005 2489
1005 2489
1005 2491
1005 2491
1005 2491
1005 188
1005 188
1005 190
1005 190
1005 190
1005 190
1016 1395
1016 2488
1016 2488
1016 2488
1016 2488
1016 2488
1016 2488
1016 796
I need this to turn into this:
B C
15 1005 2488
6 1005 2489
3 1005 2491
2 1005 188
4 1005 190
1 1016 1395
6 1016 2488
1 1016 796
HOW! please help me, any help would be greatly appreciated. I've written countless formulas but cant seem to find the answer to this simple problem xD
Bookmarks