choosing a cell from a range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using the function below i get the answer i am looking for... however, what
if two people have the same exact score? it looks like based on the function
below the first occurance is picked up... can i build some kind of warnning
or can i show both names?

Subject: RE: choosing the a cell from a range 9/12/2007 12:57 PM PST

By: excelent In: microsoft.public.excel.misc

=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0))

"Robert-Alpha" skrev:
 
The easiest way would be to use autofilter, then from the dropdown select
top 10, adjust it to top 1 and all max values will be displayed


--
Regards,

Peo Sjoblom
 
Back
Top