Find the first 12 cells in a row, >=10, and take a Average
Hi all,
I have a challenge with calculating the Average within a row of cells, based on what’s in those cells. I need to find the first 12 cells that are e.g. >=10, and take an average, but ignore cells <10 and move to the next cell if need be.
Any ideas??
Hi all,I have a challenge with calculating the Average within a row of cells, based on what’s in those cells. I need to find the first 12 cells that are e.g. >=10, and take an average, but ignore cells <10 and move to the next cell if need be. Any ideas?? Read More
