Return a reference from LARGE function

**marcusmpe** · 06-24-2008, 12:00 PM

So I want to know how I can find where the result of the LARGE function was found. I've got an array of scores with names in each row, 3 scores per name. I've attached an example of what I'm trying to do. I get the highest 3scores with the LARGE function, I just want to be able to pull the name which corresponds to each. I noticed that the MATCH function will return the column or row number, but only for a 1-row or 1-column array. If I could find the row number of the result of the LARGE function, I'm sure I could get it from there. Any help would be appreciated.
Marcus

**NBVC** · 06-24-2008, 12:15 PM

Try:

Please Login or Register  to view this content.

which must be confirmed with CTRL+SHIFT+ENTER not just ENTER.. You will see { } brackets appear around the formula.

Then copied down.

**marcusmpe** · 06-24-2008, 02:10 PM

Wow. Thanks a bunch. I'm currently trying real hard to understand it completely so I can implement it perfectly in my spreadsheet. I think I get the idea for the most part. Thanks again.

**marcusmpe** · 07-09-2008, 03:12 PM

So now i've got a summary page which lists the top three games from the whole season. Same issue of trying to determine who each game belongs to.
I think it might be easier to refer to the high games in each weekly sheet, but I'm not sure. I've attached another example.

Thanks

**NBVC** · 07-09-2008, 03:45 PM

I think it would be easiest to just list the top 3 from each Week somewhere in the Summary sheet... then you can extract the top 3 of all those along with the names using previous formulas...

**mtcas** · 03-14-2017, 10:57 AM

Is there an easier way to get cell reference or row/col number?

LARGE(A1:A4,1) > result A4 or row-4
LARGE(A1:A4,2) > result A2 or row-2
LARGE(A1:A4,3) > result A3 or row-3

A
2
4
4
5

MATCH function not working properly with two or more same number (example 4)

**JeteMc** · 03-14-2017, 01:18 PM

Hi mtcas and Welcome to Excel Forum,
Please open a new thread, include a link to this one if it has relevance to the question you are asking.
It will also help us to help you, if you will include a sample spreadsheet demonstrating what you are trying to accomplish.
To attach a sample spreadsheet click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.

**xlnitwit** · 03-14-2017, 01:24 PM

For the first match
=MATCH(LARGE(A1:A4,1),A1:A4,0)

**mtcas** · 03-14-2017, 03:33 PM

JeteMc thanks for welcome

I think that my problem is the same as marcusmpe but simplest.

xlnitwit as I wrote above, MATCH function not working in this case. At second and third value - always return 2.

I need reference to row, when large function found nth top value. xlnitwit is a good idea but not perfect

**FDibbins** · 03-14-2017, 05:13 PM

mtcas welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.