Thread: Reference to the N-largest value in an array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] michaelp@hio.no is offline
external usenet poster
  
Posts: 3
Default Reference to the N-largest value in an array
Hello

I need a formula that can give me the the array-reference of the N-
largest value in the array.

Something like:
referenceToLarge(A1:B5, 2) that gives me "A3", if A3 holds the second
largest value in the range A1:B5.



Thanks

Michael

Reply With QuoteReply With Quote