# Add next non-used digit to value

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.

BruceWayne
answered question

### 1 Answer

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.

BruceWayne
posted this

## Have an answer?

JD