up level of references.

agnes ng

New Member
Joined
Oct 3, 2005
Messages
27
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
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

agnes ng

New Member
Joined
Oct 3, 2005
Messages
27
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

New Member
Joined
Oct 24, 2005
Messages
31
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

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
hi agnes,

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

Watch MrExcel Video

Forum statistics

Threads
1,119,144
Messages
5,576,330
Members
412,716
Latest member
thviid
Top