Ranking when multiple numeric values repeats in a column

Hi Anonymous,

In essence it did work - however, it still won't let me sort by 'Rank' in the tabel viewing... I think I misunderstood the ranking issue the program informed me about. The problem is probably more the fact that my label names repeats itself in multiple variables, fx the option 'male' is both a possible answer in variable 1, 5 and 7. Thus, the ranking number for the option 'male' needs to be the same to solve the 'sort by' issue in tabel viewing. But creating a ranking based on the label name randomise the natural order of fx education. Then the answer 'no education' has rank 136, 'bachelors degree' has rank 112 and 'primary education' rank 188. So, I need to create a column which ranks according to the natural order within the questions (defined by the numbers of the 'answer'-column), but repeats a rank number if the label name has already been given a number before, and at the same time each unique label name needs to have a unique rank number.

Is it something you by any chance also know the answer to? 

Best regards,
Laura