Excel Formula for auto numbers

Question

I am in need of some help.&nbsp; I have a string of text that I have put together and need a final unique number at the end.&nbsp; So for example ABL267 is strung together and will be used again I need a nonrepeating number that will be at the end. The table below is an example the id column I would like to be automated. Thanks for the help.FIN#&nbsp;Product FamilyFixture ComponentManufacturing ProcessMACHINE #idABL267A001&nbsp;ABL267A001SFA485A001&nbsp;SFA485A001ZWM262A001&nbsp;ZWM262A001ABL267A002&nbsp;ABL267A002

hansvogelaar · Answer

Orion086&nbsp;
See the attached workbook. I used one extra column.

orion086 · Answer

That is fantastic thank you. I was trying to do that but I was getting errors.Adam&nbsp;HansVogelaar&nbsp;

Forum Discussion

Excel Formula for auto numbers

2 Replies

FIN#	Product Family	Fixture Component	Manufacturing Process	MACHINE #	id
ABL267A001	A	B	L	267	A001
SFA485A001	S	F	A	485	A001
ZWM262A001	Z	W	M	262	A001
ABL267A002	A	B	L	267	A002