Add next non-used digit to value

2439 views excel

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


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


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

posted this

Have an answer?


Please login first before posting an answer.