Rank the Data
 

Is there any way to rank the data using a macro, or is there an easier
way?

Basically I have a list of data sorted by state. I want to rank the
data from high to low(1st, 2nd, or 1,2, etc.), but not sort the data (I
want it to stay where it is with the rank to the right of the data).

How can I do this?

Thanks,

Dave

Rank the Data
 

It is easier than you might suppose: there is a RANK() function that will do
it for you:
=RANK($A1,$A1:$A50) will show A1's rank out of the list in A1-A50. NOTE:
ties are possible, so RANK will give them equal ranks and then skip the next
one - e.g. if there is a tie for 3rd rank, the rank numbers would go 1, 2, 3,
3, 5, 6 ....
--
- K Dales


"dm16s" wrote:

Is there any way to rank the data using a macro, or is there an easier
way?

Basically I have a list of data sorted by state. I want to rank the
data from high to low(1st, 2nd, or 1,2, etc.), but not sort the data (I
want it to stay where it is with the rank to the right of the data).

How can I do this?

Thanks,

Dave