Latest 24 hours avarege

F

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):
 
D

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
 
Top