Hello. I am having trouble smoothing or averaging data. Say I have data in A1 through A1000. I would like to make B1 the average of A1 - A5, B2 the average of A6-A10 and so on. Seems like it should be a simple series fill, but it won't work. Any suggestions? Thanks!
Bookmarks