choosing a cell from a range

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:
 
P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

choosing the a cell from a range 3
Backgroud color for 1 cell based on a range of cells values 3
Formula for max number and the data adjacent to the cell 3
Comparing a range of values 3
Select value from a range given a rank 2
removing a cell from an array 1
How do I pass a variable cell reference to a Range Object? 2
Can I reference =, <, or > sign in SUMPRODUCT 7

Top