Tested your array formula with the sample data below,
where the answer should be: rajesh
but it continued to return: narendra

rajesh kishor kishor
rajesh kishor rajesh
narendra rajesh narendra

Any clues ?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Daniel.C" wrote:
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))))