find the average of the first 3 non zero values of a row

**gutterball** · 08-11-2015, 02:15 PM

I have tried an array formula taking the largest average, but that is not always right.

Any ideas how to achieve this?

average.xlsx

Attached is a sample data set and the desired results.

**Pepe Le Mokko** · 08-11-2015, 02:32 PM

See attached

**gutterball** · 08-11-2015, 03:44 PM

Thank you Pepe Le Mokko,

That is an ingenious use if the index function, I will have to remember that.

**Pepe Le Mokko** · 08-12-2015, 03:13 AM

You're welcome. The INDEX function has much more to it than meets the eye

find the average of the first 3 non zero values of a row

LinkBack

Thread Tools

Rate This Thread

Display

find the average of the first 3 non zero values of a row

Re: find the average of the first 3 non zero values of a row

Re: find the average of the first 3 non zero values of a row

Re: find the average of the first 3 non zero values of a row

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Use vlookup to find the dates and then average the values in corresponding column

Formula to find average of values between negative values in 'random' array of fixed size

[SOLVED] Find average of lowest 5 values in a column

[SOLVED] Need to find average of an array if corresponding values are within a set range

[SOLVED] Find average values with conditions

Find average of values next to matching string

Find the average of the lowest four values of the last six

Bookmarks

Bookmarks

Posting Permissions