hello everyone
im trying to make a formula to give me the text in column A,, plus the test in column D, plus unique identifier (01 sequential onwards) for my table as the attached sheet
i have many versions of the FERxx so want to end up with (text column a) + (text column D) -001 for the first example where there is FER23 and FAT in columns A and D, then use the -002 identifier when i have the second time "FER23" and "FAT" in columns A and D.
im very new at getting the formula to work on the sheet, but do know how to enter a code into an excel sheet.
many many thanks for any help you can give me .
Cheers
Steve
Bookmarks