LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default PLACINGS FROM HIGH TO LOW

I am using Excel 2003. I know a bit outdated but oh well. My challenge to
anyone is this:

I want the table to display the following information:
answer is: A Colum 500 therefore came in B Colum 1st Place
A Colum 450 therefore came in B Colum 2nd Place
A Colum 400 therefore came in B Colum 3rd Place
and continue this on for many answers that I have with the placings.
Should sound easy but i do not know what function i should use. Please help
the so confused novice. I do not have any books on excel so could not look
this info up.
 
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
In col if high is 83 and low 15 how do i get high =100 and low=0 Sarah Excel Discussion (Misc queries) 2 December 7th 07 12:30 PM
High = 4 Formulas Excel Worksheet Functions 7 October 8th 07 04:10 PM
High = 4 take 2 High = 4 take 2 Excel Worksheet Functions 4 October 5th 07 04:49 PM
Displaying winner/first four placings. Toobi-Won Kenobi Excel Worksheet Functions 5 April 28th 07 05:18 PM
Formula for placings, using 4 times and greater than minimum time handers Excel Worksheet Functions 2 May 12th 05 08:00 PM


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