Hi guys,

May be quite simple for some of you and could use some help.

I have one column with

234
234
234
235
235
235
235
236
236

I need to make it into a number series but keep the same format-as in 235 becomes 1, 235 becomes 2,etc so the column would look like

1
1
1
2
2
2
3
3

Sorry for the long post but I find it easiest to express my problem this way. Thanks.