Sequences

Hi,

I have these sequences displayed in column F - 120723_1

To create another sequence I have created this formula in column M , =IF(F2="","-",F2&"_"&COUNTIF(F$2:F2,F2)), which gives a value of 120723_1_1

The problem I am having is that some of the data in column F is blank, giving a value of _ , but column M now sequences these blanks as _1, _2 etc and my formula within another sheet is calling up these incorrect values.

Is there anything I can do within the original formula to ignore the blanks or is there something I can change in my final formula as follows - =IF($T11="","",IF(ISNA(MATCH($T11&"_"&COLUMN(A$1),'[GRN History (2 Year).xlsx]Sheet1'!$M:$M,0)),"",INDEX('[GRN History (2 Year).xlsx]Sheet1'!$A:$A,MATCH($T11&"_"&COLUMN(A$1),'[GRN History (2 Year).xlsx]Sheet1'!$M:$M,0))))

Maybe:

=IF(M2="-", "-", YourFormulaHere)

Maybe:

=IF(LEN(M2)<5, "", YourFormulaHere)

Very possible, but we're working blind here. Posting pictures is often useless.

Make a small sample workbook showing good sample data AND MANUALLY MOCKED UP results so we see what the output should be. Should make things quicker.

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.

M14: =if(d14="","-", f14&"_"&countif(f$2:f14,f14))

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.