please see below image to understand what i want to do.
John has serial# 1001, when john is repeated on client column, serial# is same as it was on first entry. How can i automate this process in excel?
Asked
Active
Viewed 157 times
0
-
Do you always write the client Name in the same way? which formula you use for the serial number? – yass May 09 '17 at 19:49
-
yes i always name in the same way. First i assign a serial number to a client, and then my team calls to clients. When i make a summary it's bit difficult to me recognize the thousands to clients. – Muhammad Naeem May 09 '17 at 20:08
2 Answers
2
Put 1001 in A2. Then in A3 put:
=IF(B3<>"",IFERROR(INDEX($A$1:A2,MATCH(B3,$B$1:B2,0)),MAX($A$1:A2)+1),"")
And copy it down the column.
Scott Craner
- 148,073
- 10
- 49
- 81
-
Please mark as correct by clicking on the check mark by the answer. – Scott Craner May 09 '17 at 20:06
-
Craner can you please edit this formula e.g i want client first name and last name separate columns. Auto increment will not took place until first name and last name columns are filled by user. Thanks – Muhammad Naeem May 21 '17 at 09:43
-
-
-
Thanks dear, but it is very difficult me to use technical language to write a typical question like it is. Somehow i will try my best if reader can understand what i want to say. Thanks for your reply. – Muhammad Naeem May 22 '17 at 18:52
