Excel Ranking tie issue -
does 1 know how deal tie records issue in excel? want show record 1 time on first occurrence. if same number found twice, not show show above.
to results shown can utilize "array formula" in aa2
=if(or(z2=0,countif(z$2:z2,z2)>1),"",sum(if(frequency(if(z$2:z$19>z2,z$2:z$19),z$2:z$19),1))+1)
confirm ctrl+shift+enter , re-create formula downwards column
see sample file
excel ranking tie
No comments:
Post a Comment