Dynamic Counting with "Text"

[slapcity]

Hi there,

I have a searched through the forums, and may be searching via the wrong words, but am having challenges putting together probably a relatively simple formula.

I need Excel to automatically update a numbered column when a cell may be deleted or changed to alternative text, for example:

2017-129
2017-130
2017-131

If 2017-130 was adjusted Excel would automatically update:

2017-129
blank
2017-130

I believe I have created a formula system to do just this, however, I cannot figure out how to add in the "2017" so it does not change. Here are the formulas I have set up for the dynamic counting:

Formula 1: =IF(B450>0,129,"")
Formula 2: =IF(B451>0,MAX(A$450:A450)+1,"")

Any help or suggestions would be greatly appreciated!

 

[wideboydixon]

You *could* highlight column A, press Ctrl+1, select the Number tab and use a custom format:

"2017-"0

WBD

 

[slapcity]

You *could* highlight column A, press Ctrl+1, select the Number tab and use a custom format:

"2017-"0

WBD

Thanks! This seems to work perfectly (knock on wood). Somehow the simple formatting always escapes my mind!