Hi
I have 4 columns with data for every minute of the day (1440 entries)
In one cell I want to have a running average
of the data that is available at the time that I ask for it, even if there is no data for the full hour.
A1:A60,B1:60,C1:60 and D1:60 In e60
Can any one tell me how to do thisusing the example below with only five minutes of data, with out getting an error.
A B C D
22 45 56 98
12 23 76 98
12 46 90 98
33 88 77 66
22 99 99 89
Thank you for your time,
Jim
I have 4 columns with data for every minute of the day (1440 entries)
In one cell I want to have a running average
of the data that is available at the time that I ask for it, even if there is no data for the full hour.
A1:A60,B1:60,C1:60 and D1:60 In e60
Can any one tell me how to do thisusing the example below with only five minutes of data, with out getting an error.
A B C D
22 45 56 98
12 23 76 98
12 46 90 98
33 88 77 66
22 99 99 89
Thank you for your time,
Jim