Do you max per Row, Column or the Whole area ?
Please give an example result
yay, It works!!! Thanks sire, this is great!In N5, array formula copy down :
=IFERROR(INDEX(G5:L5,MODE(IF(G5:L5>0,MATCH(G5:L5,G5:L5,0)))),"No duplicate text entries")
p.s. array formula to be confirmed pressing with SHIFT+CTRL+ENTER 3 keystrokes together
Regards
Bosco
Hi sir,Hii,
you can use below formula also .
try this in N5
{=INDEX($G$5:$L$5,MATCH(MAX(COUNTIF(G5:L5,G5:L5)),COUNTIF(G5:L5,G5:L5),0))}
Note:array formula to be confirmed pressing with SHIFT+CTRL+ENTER 3 keystrokes together
Thanks
rahul shewale