arrun
08-12-2008, 12:06 AM
I have folowing dataset :
Price
1-Jan-05 1400
2-Jan-05 1400
3-Jan-05 1400
4-Jan-05 1390
5-Jan-05 1375
6-Jan-05 1370
Now I want to calculate average for the subset of data. Like average price before and on 4-Jan-05 (this entry is again at some cell say, A10) i.e I want to get average value of 1st four price. Can anyone please tell me how to do that?
Price
1-Jan-05 1400
2-Jan-05 1400
3-Jan-05 1400
4-Jan-05 1390
5-Jan-05 1375
6-Jan-05 1370
Now I want to calculate average for the subset of data. Like average price before and on 4-Jan-05 (this entry is again at some cell say, A10) i.e I want to get average value of 1st four price. Can anyone please tell me how to do that?