up level of references.

[agnes ng]

i got a problem here

my part numbering is 12345-01. The last 2 digit is a reference number.

I need a formula whereby if the number before the dash appears the same, the reference number will increase one level. resulting 12345-02 and so on.

is there a formula to help?

please advise. Thanks

 

[nbrcrunch]

I need a formula whereby if the number before the dash appears the same

Appears the same as what?

 

[agnes ng]

meaning if i got a part number 12345-01, and if there's repeated number in first 5 digit, the last 2 digit will up one level to 12345-02

 

[Rogie]

I am not sure you can do it by a simple formula since you have to reference previous part numbers before it. Through a macro, maybe.

 

[nbrcrunch]

hi agnes,

I am sorry but I still don't understand. Give some examples of a repeated number.