Prev: Excel's COMBIN and integers
Next: Conditional Sum - Moving Average
From: dexter on 27 Mar 2010 21:32
HOW CAN I USE "MODE" ON WORDS (NAMES OF PEOPLE)?
From: T. Valko on 27 Mar 2010 21:48
Tom
Sue
Sue
Bob
Sue

Array entered** :

=INDEX(A1:A5,MODE(MATCH(A1:A5,A1:A5,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.

Result = Sue

--
Biff
Microsoft Excel MVP


"dexter" <dexter(a)discussions.microsoft.com> wrote in message
news:C71D85F8-87A4-44C0-91BC-C59750ADF8DE(a)microsoft.com...
> HOW CAN I USE "MODE" ON WORDS (NAMES OF PEOPLE)?


 | 
Pages: 1
Prev: Excel's COMBIN and integers
Next: Conditional Sum - Moving Average