Hi
to get the most frequent text entry try the following array formula
(entered with CTRL+SHIFT+ENTER):
=INDEX($B$1:$B$20,MODE(MATCH(IF($B$1:$B$20<"",$B$ 1:$B$20),IF($B$1:$B$2
0<"",$B$1:$B$20),0)))

if you put this formula in C1 put the following formula in D1 to get
the associated number:
=INDEX($A$1:$A$20,MATCH(C1,$B$1:$B$20,0))

Note: this returns the number for the first match of Nassau in column B


--
Regards
Frank Kabel
Frankfurt, Germany


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/