2 Man Best Ball Formula

[Jaywk007]

Hello All,

I am in need of a golf formula to show the best ball score of 2 scores.

Ex. Golfer 1 scores are in cells B5:J5 (1 number in each cell) and in cells L5:T5
Golfer 2 scores are in cells B6:J6 (1 number in each cell) and in cells L6:T6

I need cells B7:J7 and L7:T7 to pick the lowest number of the 2 cells above them and display it AND if both cells are the same number then display only one of the numbers.

I assume any formula will go in cell B7 and carry across the sheet?

Thanks for the help

 

[AhoyNC]

=IF(B5=B6,B5,MIN(B5:B6))

 

[Fluff]

Another option

=MIN(B5:B6)

 

[Jaywk007]

Thanks for the solutions.......I figured it out not long after posting the question. I must have had a brain lock last night while initially trying to figure it out.

Thanks again

 

[Fluff]

Glad we could help & thanks for the feedback.