One way:
=RANK(A1,A:A,1)

HTH
--
AP

"Cossloffe" a écrit dans le message de
news: ...
Dear gentlemen,

I have a list of values. These values range from f.e. 1 till 30 but the
same
value comes several times forth. I would like to assign for each value a
number and I would like for excell to do it for me.. (since the amout of
values is high). how can I do this?