Hi,
I have a report that categorises the regions into different catergories for.
e.g.

Region Population Category Education Category Job Category
1 A B
A
2 B C
C
3 A A
A
4 B C
B
5 C B
A

I'm looking for a formula that will check the categories i.e. A, B or C and
give a result in the form of max appeared i.e. in case of Region 1, A appears
twice and in case of Region 4, B appears twice. Or else if all categories are
equal then the result populate the category in Population criteria i.e. in
Region 5 all A, B & C categories appears hence it gives me the result as C
that appears under Population criteria.

Please help and advise.
thanks, nsd