hello,
I'm trying to create a function that will take the average of the last 25% of that data entries in a given range. In my example, I have 30 days of data, cells A1:A30. This data is going to grow on a daily basis so I need a function to be able to automatically adjust. I would like to take the average of the last 25% of this data. Days with blanks do NOT count. Also, taking 25% of numbers will not always give a whole number, so I would just like that to round up to the next whole number. In my example, 25% of 30 is 7.5, round that to 8. So this function would take the average of the last 8 cells that contain data (blank cells do not count). The resulting average would be 91.54 which can go in cell C1
Thanks
Bookmarks