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