Thread: Highest value cell and ajacent cells
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Highest value cell and ajacent cells
Hello,

LARGE is no big help if you can have dupe values. I suggest to use a
helper column with a unique rank:
http://sulprobil.com/html/rank.html

A helpful example might be:
http://sulprobil.com/html/sorting.html

Regards,
Bernd
Reply With QuoteReply With Quote