can numbers be assigned to values, replacing values for numbers
 

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?

can numbers be assigned to values, replacing values for numbers
 

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?

can numbers be assigned to values, replacing values for numbers
 

Do you mean you want to count the instances of each number?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Cossloffe" wrote in message
...
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?