count and index issue

Originally Posted by NBVC

here: COUNTIF($D$14:D16,D16)=1 you are saying if the Count from D14 to D16 of value in D16 is 1 then submit Row number... there are 3 John Doe's so it will not equal 1 and therefore it will return the FALSE part (i.e. Null). When you change D16 to J. Doe, then your count of J.Doe is 1 and so you get Row number returned...

any suggestions how i can avoid that....yet at the same time on my "rps contest payout" sheet, have the name only appear once? thxs for your input.