View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
so confused so confused is offline
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.