Another way to do it (array formula, validate with Ctrl+Shift+Enetr) :
=INDEX(A1:C3,MAX((IF(COUNTIF(A1:C3,A1:C3)=MAX(COUN TIF(A1:C3,A1:C3)),1,0)*ROW(A1:C3))),MAX((IF(COUNTI F(A1:C3,A1:C3)=MAX(COUNTIF(A1:C3,A1:C3)),1,0)*COLU MN(A1:C3))))
HTH
Daniel

sir,
i have 2nd list like
A B C
1 rajesh kishor narendra
2 rajesh kishor narendra
3 narendra narendra narendra
4 Result will be here i.e. narendra


and i want to find above maximum name with result max time


plese help me

thanking you