# Method to number unique values

Hello World :)

I have a calc-sheet with some 900000 lines in it. In one of the columns the same text values keep showing up. There are about 750 different text values.

it looks like this:

- AAA
- AAA
- BBB
- AAA
- AAA
- AAA
- CCC
- BBB

So now I would like to add a number next to every unique value. The same number every time that is.

Ideally it would look like this:

- AAA 1
- AAA 1
- BBB 2
- AAA 1
- AAA 1
- AAA 1
- CCC 3
- BBB 2

How would I go about this ?? Do I really have to auto-filter, select one of the values and copy paste the correct number in the column next to it (repeated 750 times!!) or is there an easier way ??

All help greatly appreciated !! Thanks in advance :)