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
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
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Thanks Admin. Think it needs a slight tweek as its not displaying the correct item number in colum A. I am attaching the source file. Can you take a look and advise. Many thanksAttachment 570
Posting Permissions
Reply With Quote
Bookmarks