ExcelBanter - how can get average of 3 max values out of 7 values in a row

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - how can get average of 3 max values out of 7 values in a row (https://www.excelbanter.com/excel-programming/400146-how-can-get-average-3-max-values-out-7-values-row.html)

Mobin

how can get average of 3 max values out of 7 values in a row

how can get average of 3 max values out of 7 values in a row

excelent

how can get average of 3 max values out of 7 values in a row

=AVERAGE(LARGE(A2:A8,{1,2,3}))

"Mobin" skrev:

how can get average of 3 max values out of 7 values in a row

All times are GMT +1. The time now is 04:26 PM.