Search results

Works well in sample workbook. In my primary workbook I have a dynamic list so there are blanks...thus #DIV/0! error. I can definitely use this in other scenario though. Thank you.

Yep works fine in sample and adapted to production workbook and works in my dynamic list. Thank you.

In reference to http://chandoo.org/wp/2010/06/04/average-of-top-5-values/. This formula allows you to average 3 numbers at a time in consecutive rows: =IF((ROW()-2)<CEILING(COUNT($B$2:$B$13)/3,1),AVERAGE(OFFSET($B$2,3*(ROW()-2),0,3)),"") Is it possible to do this by % of the largest values...

Thank you Deb and Narayan for your time. @Deb your array formula indeed works. I will need to go through and edit some of my other formulas based and what you've shown me here. And I'll need to dig in to really understand what's going on with the formula. I will end up with about 5,000...

Hello everyone. First post here. I learned how to write a formula from this forum a while back and I use it in several places in a spreadsheet. I've recently started a new data set for 2013 and I noticed something odd. I have several ranges that I reference in it. Basically what it's...