Write 1 in A1, and in A2 use =IF(ISNUMBER(MATCH(B2,B$1:B1,0)),INDEX(A$1:A1,MATC H(B2,B$1:B1,0)),MAX(A$1:A1)+1) and drag down