Hello All,
I've looked for the solution for a while and I can't find what I need.
Here is my Data and Column C is what I want to happen
A (ID) B (region) C(Count unique occurrence)
2 metro 2
2 suburban 2
3 rural 1
4 rural 3
4 metro 3
4 suburban 3
5 metro 1
5 metro 1
I would really appreciate a formula that allows C to happen.
Thanks
Zeda
Bookmarks