Move your data down 1 row and put labels in row 1 ("Code" and "Region"). Use
a pivot table with "Region" as a row area and sorted in descending order by
count of Region.

--
Regards,
Bill


"nrage21 " wrote in message
...
I have the following list:

A........B
102...Nassau
102...Nassau
102...Nassau
102...Nassau
102...Suffolk
102...Suffolk

I need a function to return the text that appears the most in column
B;...... that would be "Nassau" and that co-relates to "102" or any
other designated #.


- Larry -
VBA Amateur


---
Message posted from http://www.ExcelForum.com/