how findout max data like text, any word in excel

  • Thread starter Thread starter how findout max data like text, any word
  • Start date Start date
H

how findout max data like text, any word

sir,
i have list like
rajesh
kishor
narendra
rajesh
rajesh
kishor
kishor
rajesh

and i want to find above maximum name with reslut rejesh is max time i.e 4
time

plese help me
 
Hi,

Try this. there mustn't be any blanks in the range

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

This is an array formula which must be entered with CTRL+Shift+Enter and NOT
'just enter. If you do it correctly then Excel will put curly brackets around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array

Mike
 
Hi,

You can try with subtotals also and you would get the results exactly like
you have desired.
 
Back
Top