how findout max data like text, any word in excel
 

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

how findout max data like text, any word in excel
 

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



"how findout max data like text, any word" wrote:

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

how findout max data like text, any word in excel
 

Hi,

You can try with subtotals also and you would get the results exactly like
you have desired.
--
Thanks
Suleman Peerzade


"how findout max data like text, any word" wrote:

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