Hello there,
I am working with Excel 2010 and am trying to add a letter to a duplicate line. I found a formula that gets me a number and that is where I get stuck.
This is the formula:
=C2&IF(COUNTIF($C$2:C2,C2)=1,"",COUNTIF($C$2:C2,C2)-1)
The results are:
2345
3333
33331
33332
3456
What I need is:
2345
3333
3333A
3333B
3456
Thank you in advance for the help.
Are the numbers always 4 long or 5 long when they have the extra digit you want to identify?
If so, then.
=IF(LEN(C2)=5,LEFT(C2,4)&IF(RIGHT(C2,1)=1,"A",IF(RIGHT(C2,1)=2,"B",IF(RIGHT(C2,1)=3,"C",IF(RIGHT(C2,1)=4,"D",IF(RIGHT(C2,1)=5,"E",IF(RIGHT(C2,1)=6,"F",IF(RIGHT(C2,1)=7,"G",IF(RIGHT(C2,1)=8,"H",IF(RIGHT(C2,1)=9,"I",""))))))))),C2)
Last edited by mrshl9898; 04-17-2017 at 07:22 PM.
How about...
=C2&IF(COUNTIF($C$2:C2,C2)=1,"",CHAR(COUNTIF($C$2:C2,C2)-1+64))
Last edited by jeffreybrown; 04-17-2017 at 07:32 PM.
HTH
Regards, Jeff
Re: How to add letter to duplicated line to create unique entry
Thank you Jeff,
That worked perfect in my sample data. I will test it with our client data tomorrow.
To mrshl9898,
The data length changes in the column. It is for part numbers that are going to be imported.
Thanks again,
Don
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks