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

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):
=AVERAGE(IF((A1:A1000<=NOW())*(A1:A1000=NOW()+1), B1:B1000)

-----Original Message-----
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
.

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

-----Original Message-----
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):
=AVERAGE(IF((A1:A1000<=NOW())*(A1:A1000=NOW()
+1),B1:B1000)

-----Original Message-----
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
.

.

Hi
and in your example which would that be?

--
Regards
Frank Kabel
Frankfurt, Germany


deepwater wrote:
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

-----Original Message-----
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):
=AVERAGE(IF((A1:A1000<=NOW())*(A1:A1000=NOW() +1),B1:B1000)

-----Original Message-----
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
.

.