Did you look? Try =FREQUENCY
<-*-<-*-<-*-<-*-<-*-<-*-<-*-<-*-
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-<-*-<-*-<-*-<-*-<-*-<-*-<-*-
"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/