A5: 1
A6: =IF(COUNTIF(C$5:C5,C6),INDEX(A$5:A5,MATCH(C6,C$5:C5,0)),MAX(A$5:A5)+1)
Copy down to A20
A5: 1
A6: =IF(COUNTIF(C$5:C5,C6),INDEX(A$5:A5,MATCH(C6,C$5:C5,0)),MAX(A$5:A5)+1)
Copy down to A20
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks