I want to assign a ranking number to a series of values.
 

I want to take a column of numbers and assign a rankig number from highest to
lowest. I want the Rank to auto calculate... see example.
A (value) Rank
98 1
32 3
24 4
36 2

I want to assign a ranking number to a series of values.
 

Use the rank function. See he
http://www.techonthenet.com/excel/formulas/rank.php

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"tdkdik" wrote:

I want to take a column of numbers and assign a rankig number from highest to
lowest. I want the Rank to auto calculate... see example.
A (value) Rank
98 1
32 3
24 4
36 2