LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Oscar
 
Posts: n/a
Default Location of n-th highest value in the range

How can I get location of n-th highest (parameter) value in the range of
values. In case of equal values I want first occurance to be higher ranked.

Thanks, Oscar.
 
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
FORMULA at Source range (in Data-validation-List) gives wrong re Eddy Stan Excel Worksheet Functions 6 March 17th 06 07:19 AM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
How do I return the highest value in a range of cells pjs83 Excel Worksheet Functions 5 July 6th 05 09:25 PM
How do I add only the highest three numbers in a range of data? emac_mommy Excel Worksheet Functions 4 January 9th 05 09:40 AM


All times are GMT +1. The time now is 06:02 AM.

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"