Try this array formula** :

=INDEX(A1:A20,MODE(MATCH(A1:A20,A1:A20,0)))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

Assumes no empty cells within the range and there is at least one duplicate
entry. Also note, if there are equal duplicates the formula will return the
1st duplicate.

A
B
A
B
C

Both A and B have the same number of entries but A is listed 1st so the
fromula will return A.

--
Biff
Microsoft Excel MVP


"camsown" wrote in message
...
I have a sheet that contains employee initials in one column. I am trying
to
figure out a way for Excel to derive the most used set of initials with
out
having to tell it all the possible initials. Is there a formula for this?