View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Crash1 Crash1 is offline
external usenet poster
 
Posts: 1
Default Excel Rankings function


Hello all.

I am at a impasse with trying to use the Rank function in Excel.
Basically, I'm lost. I'm trying to have excel rank a column of numbers.
The rank goes below each number--such as: (The rankings are supposed to
be centered below the number)
17.5---17.8
--1-------1
17.4---17.7
--2------2
I had a person formulate them for rank a set of 12 numbers.
Unfortunately, that person passed away before he
could finish this project. I the need the formula to rank up to 60
numbers. I've tried following the functions he did, but I get lost
very easily. I'm not very well versed in Excel.
Please contact me if you can help me with this. I really would
appreciate this. I can also email you the formula that I have so I can
show you what I have so far.
Thanks in advance.

Gregg


--
Crash1
------------------------------------------------------------------------
Crash1's Profile: http://www.excelforum.com/member.php...o&userid=36727
View this thread: http://www.excelforum.com/showthread...hreadid=564548