most popular keyword
A few mo
=INDEX(A1:A20,MATCH(MAX(COUNTIF(A1:A20,A1:A20)),CO UNTIF(A1:A20,A1:A20),0))
(this is a CSE function)
=INDEX(A1:A20,MODE(MATCH(A1:A20&"",A1:A20&"",0)))
HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"T. Valko" wrote:
Try this array formula** :
Assumes no empty cells within the range. If there are no duplicates the
formula returns #N/A.
=INDEX(A1:A10,MODE(MATCH(A1:A10,A1:A10,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.
--
Biff
Microsoft Excel MVP
"Tony_student" wrote in message
...
How to define the most popular keyword within one list?
|