dear gentleman,

There is a list of values f.e. 1 till 38, these values will repeat
themselves..in the list. I would like to assign a number to each of these
values, the thing is, the list of values is long and mixed. So I want for
excel to do it for me. how can this be done?

f.e. value 15 is assigned the number 10 and thus every time it is met on the
list excel will assign the number 10 for to value 15. who can help me with
this?