Latest 24 hours avarege

[deepwater]

We have some hourly data for every day 24hours, is it
possible to get the average for latest 24 hours. if so
pelase help me.

Thanks in advance

 

[Frank Kabel]

Hi
not that much data/information. Lets assume you have in
column a a date/time value and in column B the values for
which you want to get the average.

Enter the following array formula (with CTRL+SHIFT+ENTER):

 

[deepwater]

I am Sorry Fran..Here is the Data Like This. I need to get
latest 24 Hours
Date Time Value
5/1/04 1 350
2 450
3 650
4 750
5 850
6 650
7 300
8 450
9 650
10 250
11 300
12 200
13 450
14 850
15 200
16 324
17 123
18 324
19 345
20 546
21 456
22 234
23 234
24 345
5/2/2004 1 250
2 450
3 650
4 750
5 850
6 650
7 300
8 450
9 650
10 250
11 300
12 200
13 450
14 850

 

[Frank Kabel]

Hi
and in your example which would that be?