Hi there,
I'm trying to create a formula that takes the last 15 days worth of data. I can't just use the Average formula and select the last 15 rows as some rows will be blank and I need the average of the last 15 data points, even if it takes more than 15 days to get it. If I use the last 18 days there will definitely be 15 data sets in there, but I don't know what the formula would be to create an average for it.
Thanks a lot!
Bookmarks