Forum Discussion
Golf Handicap spreadsheet, fixing cells
I have set up a golf handicap spreadsheet for 12 people in my playing group that calculates the best 8 scores from a list of 12 then averages them out to create a playing handicap. When I insert new...
Very good solution, thank you. With the named ranges can we as well calculate the average of the best 8 results of the last 12 scores? The formula with cell ranges and the expected result is in cell E18 in the attached file.
Te devuelvo el excel,
te he puesto en la celda J1 la formula que saca el promedio de los 8 MAYORES resultados de los últimos 12 partidos
te he puesto en la celda J2 la formula que saca el promedio de los 8 MENORES resultados de los últimos 12 partidos
en la celda L1 te he puesto una formula que saca los 12 últimos partidos.
espero que te sirva