Hi folks.....

I have a list of names that may have duplicates.
I need to write a formular in a cell that will return the most commonl
used name.

ie.

Jack
John
Fred
Bill
Jack
John
Steve
Jack

As in the column above the most commonly used name is "Jack"
Is there a formular or combination of formular that I can enter into
cell or cells that will give me the same result?

Thanks for your help.

Celtic_Avenger
:confused

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