I have a very large Excel 2007 database (over 13,000 entries) and I need to
transfer the data into SPSS. In order to do so, I need to convert one column
of text-labelled data (people's names) into numerical identifiers. However,
some people are deliberately included on more than one row. What I want to do
is find a way of allocating a unique numerical identifier to each unique
entry, NOT to each row of data. In other words, I want each person to have
their own ID which will be the same regardless of whether they appear in row
1, row 5000 or row 12,000 of my dataset.

Can somebody please explain how I go about doing this, please? Many thanks!