Hello Fotis

Thxs for the input however, when i used your formula

=IF(G14='RPS Contest Payout'!$D$37,IF(COUNTIF($D14:D14,D14)=1,ROW(),""),"")

it does function how i want, however...in the "rps contest payout" sheet, it shows the name multiple times, instead of just once...any thoughts? thxs alot.