Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2006

Tip: Looking for answers? Try searching our database.

Sorting a List

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tom G - 25 Nov 2006 01:31 GMT
Hi,

In column A I have a list of dollar values.

$40
$-30
$10
$0
$0
$120

What I would like to do is in column B put a ranking 1through whatever
corresponding to their dollar value so it would look like this:

$40    2
$-30   6
$10    3
$0      4
$0      4
$120  1

I hope I explained it well.  In other words, in column B,  they are
sorted according to rank right where they stand.  $120 is number 1.
$-30 is number 6, etc.

Thanks,

Tom
Dave Peterson - 25 Nov 2006 04:06 GMT
In B1:
=rank(a1,$a$1:$a$6)
and copy down to B6

> Hi,
>
[quoted text clipped - 24 lines]
>
> Tom

Signature

Dave Peterson

Tom G - 25 Nov 2006 08:44 GMT
>In B1:
>=rank(a1,$a$1:$a$6)
[quoted text clipped - 28 lines]
>>
>> Tom

Thank you, that worked perfectly.

Tom
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.