LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default Compare Multiple Numeric Values

Hey everyone...

I was wondering what the easiest way would be to compare 3 nmueric
values, rank them, and return 3 "text" results. Here is my issue:

I have 3 cells, A1, A2 and A3, that look at numerical values in cells
B1, B2 and B3. What I need to do is have the rankings, 1st, 2nd and
3rd appear in the cells in the A column (respectively), based on the
"position" of the numeric values in the B column. So in short...

A B
1st 10
2nd 9
3rd 8

or...

A B
2nd 9
1st 10
3rd 8

The numbers in column B will change constantly, so I need column A to
adjust automatically.

Thanks to everyone for any help on this!!

 
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
Compare alpha and numeric values within a range Greg Excel Worksheet Functions 9 May 5th 06 05:17 AM
Return Summed Count of Multiple Consecutive Numeric Values Sam via OfficeKB.com Excel Worksheet Functions 4 April 10th 06 10:35 PM
multiple numeric values applied to single text Fam via OfficeKB.com Excel Discussion (Misc queries) 5 February 2nd 06 08:17 PM
How to compare multiple cell values Chirs Excel Programming 3 June 10th 05 02:03 PM


All times are GMT +1. The time now is 08:56 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"