Prev Previous Post   Next Post Next
  #1   Report Post  
Tim Sullivan
 
Posts: n/a
Default Ranking

I have a column with 24 numbers. I want to rank them. Using the standard
rank function works fine until one of the numbers is a negative.

They way I want it to rank is as follow
Rank Number
1 -360
2 -250
3 75
4 50
5 22
6 9
7 4.5
8 .06
9 0

The higher then negative number, the higher the rank. A negative number is
ranked higher than a positive number. A low positive number is ranked lower
than a high positive number. Does this make sense?????????

Any help wopuld be appreciated
--
Tim
Sorry about the duplicate post in another area
--
Tim
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Numbers used for Ranking Lowkey Excel Worksheet Functions 4 May 27th 05 11:26 PM
Ranking Using Grand Total nostalgie Excel Discussion (Misc queries) 0 April 9th 05 03:27 PM
Ranking Thrava Excel Discussion (Misc queries) 6 February 15th 05 10:49 AM
ranking an row of values Wazooli Excel Worksheet Functions 4 December 13th 04 10:09 PM
Problem with ranking numbers Pati M Excel Worksheet Functions 1 November 23rd 04 11:29 PM


All times are GMT +1. The time now is 06:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"