I have a report that has 4 columns of numbers 0 - 9, about 1500 rows deep, what I would like to be able to do is simple, but I can't seem to get my brain wrapped around it tonight. I need to find the most frequent occurring number in each column (got that part), then compare the top three from column A to the top 3 from col. B, etc.

Not to give away any information I'm not allowed to, think of it like this"



0 - Apples A - Northeast
1 - Oranges B - Southeast
2 - Grapes C - Northwest
3 - Plums D - Southwest

-------- data --------- -------------- Results ---------------
A B C D A B C D
1 0 1 3 6 0 1 0 0 0 0 0 0
2 2 4 3 2 1 0 1 2 1 0 1 0
3 2 1 7 5 2 2 2 1 2 0 2 1
4 4 2 5 9 3 0 3 0 3 2 3 0
4 1 4 1 4 0 4 0

What I cant seem to get is:
A B C D
2 1 3 2


I can't seem to be able to combine 4 "Countif"s statements...


--
Live simply...Love generously...Care deeply...Speak kindly...Leave the
rest to God.


--
Live simply...Love generously...Care deeply...Speak kindly...Leave the
rest to God.