Google Sheets: Average of largest values in each row of an array-CodePudding

Home > database > Google Sheets: Average of largest values in each row of an array

Google Sheets: Average of largest values in each row of an array

Time：06-11

I have an array 3 columns wide x 10 rows deep. Each row contains at least one number. I need a formula that takes the average of the largest numbers in each row.

I can easily do this by adding a 4th column and dragging the Large function down, then averaging that column, but I would like to avoid that if at all possible.

My demo sheet is here:

Page link：https//www.codepudding.com/database/437775.html

Prev:npm ERR! Cannot read property ‘match’ of undefined error handling

Next:Count number of rows where the minimum of multiple columns is less than a specific number

Tags：

arrays

google-sheets

average

Links：
CodePudding