at D2
=IFERROR(IF(ROW(1:1)>SUM($A$2:$A$5),"",IF(COUNTIF(D$1:D1,D1)=IFERROR(RANK(D1,$A$2:$A$5),0),1,D1+1)),1)
copy down
at D2
=IFERROR(IF(ROW(1:1)>SUM($A$2:$A$5),"",IF(COUNTIF(D$1:D1,D1)=IFERROR(RANK(D1,$A$2:$A$5),0),1,D1+1)),1)
copy down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks