Hi Brains Trust!
I currently have a spreadsheet with the following columns
A: Project Number
B: Functional Code
C: Document Type
D: File Location
E: Numerical Sequence

I have data entered in Columns A to D and want to look up those columns to then give me the next three digit number in sequence based on the content in Columns A to D.

Rows may have different information in Columns A to D.

For instance, the following may be in Row 50
A: B200123
B: PM
C: MIN
D: 2.4
E: ???

Then in column F I have a concatenate function to string Columns A to E together to read - B200123-PM-MIN-2.4-??? - with the question marks being '001' for the first instance of the concatenate. The reason I need the formula in column E is that this string 'B200123-PM-MIN-2.4' could be in the spreadsheet 15 times. I need the first instance to read B200123-PM-MIN-2.4-001 then further instances to read B200123-PM-MIN-2.4-002, B200123-PM-MIN-2.4-003, B200123-PM-MIN-2.4-004, as so on.

Thanks!!
JT