The most common string

[ianripping]

Is there a function in excel that could identify which word apears mos
in a list. Eg


List:
Car
Boat
Car
Car
Car
Car
Bike



The most comon string is Ca

 

[Frank Kabel]

Hi
try:
=INDEX(range,MODE(MATCH(range,range,0)))

 

[RagDyeR]

Try this *array* formula if there is the possibility of blank cells in the
list:

=INDEX(A1:A100,MATCH(MAX(COUNTIF(A1:A100,A1:A100)),COUNTIF(A1:A100,A1:A100),
0))

Must be entered with CSE (<Ctrl> <Shift> <Enter>)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi
try:
=INDEX(range,MODE(MATCH(range,range,0)))