Hi
I want to generate alphanumeric code from name mentioned in another cell.
For example : A2 = sumit , B2 = rakesh
I want A1 =sum001 and B2 = rak001
if in any cell code will repeat like sum001 then it should be converted to sum002
please help
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
=LEFT(A2,3)&TEXT(COUNTIF($A$2:A2,LEFT(A2,3)&"*"),"000")
Return to General Excel Questions
Users browsing this forum: No registered users and 249 guests