Thread: Location of n-th highest value in the range
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Location of n-th highest value in the range
Hello Oscar,

Enter in cell B1:
=COUNTIF($A$1:$A$5,"" & A1) + COUNTIF($A$1:A1,A1)
and copy this down to B5.

Works with numbers and strings.

HTH,
Bernd

Reply With QuoteReply With Quote