Thread: I want to assign a ranking number to a series of values.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default 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
Reply With QuoteReply With Quote