Hi all,

Does anyone know of a formula I can put into a column that will add -1, when the same number is entered & -2 when the number is entered again & so on?
e.g.

1
2
3
1-1
4
5
1-2
6
2-1

As always thanks for any assistance guys - Marco