Add next non-used digit to value

2439 views excel
2

Is there a formula, or series of formulas, that I can use to copy the value from a cell in the same row and add the next non-used digit to it? See image for desired result.enter image description here

answered question

1 Answer

12

If your original list is in column A, starting at A1, in B1, put this and drag down:

=A1&"-"&COUNTIF($A$1:$A1,A1)

Note that this works specifically for the data you show here.

posted this

Have an answer?

JD

Please login first before posting an answer.