Retrieving the Darts Player Who Scored the Highest Peg

**Ghostcoy** · 04-09-2010, 06:24 AM

Hi,
I'm trying to find a formula to retrieve the score of the darts player who scored the highest peg of the night. Have tried a couple of the,Index, Search, Max formulas posted here with a couple of minor adjustments, but can't get the result I require.

Have tried to attach a copy of the file, but for some reason that part of additional options is not loading properly.

P.S. Is there a virus on the site? my AV keeps giving me a warning!!

**DonkeyOte** · 04-09-2010, 06:51 AM

The site is being fiddled with by the owners - hence nothing's working properly (and the AV warning I suspect) - I'm afraid due to customary lack of communication no-one here has any idea what they're doing and truth be told we're not sure they do either.

In terms of what you want to do... assume names in A and scores in B, name of highest score:

=INDEX(A:A,MATCH(MAX(B:B),B:B,0))

modify ranges to suit of course

**Huron** · 04-09-2010, 06:57 AM

Hi Ghostcoy

I think there is a problem with the site today. I've looked at the file you attached yesterday and I think you can use the following array formula in X45 and copied down.

=MAX(IF($C$57:$BE$57=$B45,$C$36:$BE$36))

You need to unmerge the cells first and press Control - Shift - Enter to confirm the formula.

Merged cells are best avoided and you can achieve the same visual effect by selecting the 2 (or more) cells then Format Cells - Horizontal - Centre across selection.

**Ghostcoy** · 04-09-2010, 06:59 AM

Hi DonkeyOte

Have tried that formula, I posted this same question at the link below, Yesterday also attached a copy of my file.

The site was running fine then!!!!

http://www.excelforum.com/attachment...ats-sheet.xlsm

**Huron** · 04-09-2010, 07:06 AM

Sorry - my formula gives the highest peg for each player. You can then use DonkeyOte's formula to get the name of the highest of these in another cell.

=INDEX(B45:B52,MATCH(MAX(X45:X52),X45:X52,0))

**Ghostcoy** · 04-09-2010, 07:42 AM

Hi Huron

Just tried the formula you sudjested to no avail, copied & pasted down the column, and got the same result in each cell, (TRUE), not the result in only the one cell that matches.

Thanks anyway!!

**Huron** · 04-09-2010, 07:56 AM

Are you sure you typed it correctly? I don't see how a MAX formula can return TRUE

**Ghostcoy** · 04-09-2010, 08:50 AM

Hi Huron

Yes mate I entered correctly, I copy and pasted both formulas.

=MAX(IF($C$57:$BE$57=$B45,$C$36:$BE$36)) gave me an answer of TRUE in all cells.
And.
=INDEX(B45:B52,MATCH(MAX(X45:X52),X45:X52,0)) gave me an answer of 0 in all cells.
If I enter
=MAX($C$57:$BE$57,$B45,$C$36:$BE$36) this gives me an answer of 68 in all cells, just can't quite get it to pick between players, even though I've changed $B45 to $B46 and so on down the column.

**Huron** · 04-09-2010, 09:12 AM

See the attached file

**Ghostcoy** · 04-09-2010, 10:59 AM

Hi Huron

That's great. Looks like you saved my bacon again, as I think I remember you helping me with another part of this sheet. Top marks mate 100 out of 10.