Moving Range Formula

[btadams]

Anybody have an idea for a formula that calculates moving ranges? For example, Column A contains dates and column B contains data. I need a formula in column C that will calculate the within-day range but only in the last cell for that day. For example, if cells B20:B22 contain data for one day (the dates would be in cells A20:A22), then I want C22 to contain the within-day range.

The number of data points per day will vary from 1 to who knows. Thanks for any help!

 

[Andrew Poulsom]

Maybe try:

=IF(A22<>A23,SUMIF(A:A,A22,B:B)/COUNTIF(A:A,A22),"")

which you can copy up and down.