Best formula for required result

[Marvo]

Hi, I'm looking for the best formula to achieve the required result.

I've made a simple mock up. What I want is a formula in D11 to find the highest score of handicappers 18 and under. Then in D12 the highest score of handicappers 19+. If possible if there are more than one winner in each category, I'd like a return of zero or "".

Many thanks.

 

[Marvo]

Maybe if I broke it down in stages?

I need to find the highest score in Column E from the players with handicaps of 18 and under. So maybe Max coupled with IF?

Then, add up how many of the highest scores there are.

If there's just 1, then you have the winner, otherwise nobody wins.

 

[Fluff]

I understand what you are trying to do & that is what the formula I supplied should do. There is no point trying a different formula as that may hit the same problems you are already getting & then we're back to square one.

 

[Marvo]

Okay, I just don't know how to send you the workbook. I'm sorry it's causing you so much time.

 

[Fluff]

You can upload the workbook to a share site such as Onedrive, googledrive mark for sharing & then post the link you are given to the thread.

 

[Marvo]

I think I've done it. Let me know. Your formula is in G34 on worksheet Results.

Mr Excel Help.xlsx

1drv.ms

 

[Fluff]

Both columns C & D just have zeros & col E is completely blank. Hence it doesn't work.

 

[Marvo]

?????

Column C on the Masters worksheet is full of handicaps, Column E is full of formula.

 

[Fluff]

I was looking at the wrong sheet, but there are still no scores in col E, it's completely blank

 

[Marvo]

I don't understand, I've just clicked on the link and column E is full of formula

 

[Fluff]

Yes it's full of formulae, but every single one of them returns "". Therefore you have no scores to determine a winner.