View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cjrolls cjrolls is offline
external usenet poster
 
Posts: 3
Default conditional sorting

Hello, Is there a way to rank certain cells according to their value. I have
something like this. I need a formula to enter in column B which will change
as the scores in column A change. Any help much appreciated.
A B
SCORE RANK
10 4
21 3
56 2
3 5
76 1