i used the formula
however it appears is now in the "rps contest payout" sheet
cell D19
=IF(ROWS($A$1:A1)>COUNT('CSA detail breakdown'!$O$14:$O$1020),"",INDEX('CSA detail breakdown'!$D$14:$D$1020,MATCH(SMALL('CSA detail breakdown'!$O$14:$O$1020,ROWS($A$1:A1)),'CSA detail breakdown'!$O$14:$O$1020,0)))
it is listing the names twice
i have attached a sample update
any way to work around this? thx u
Bookmarks