Thanks oldchippy.
I have another question.
In Col A, day is changing from A463.
What is the best way to tell excel that it is a new day?
This is an issue because if I try to plot something vs. time, excel doesn't automatically add a next day rather starts plotting from beginning.
Thanks.
Hello,
I have attached a file with this question.
http://www.megaupload.com/?d=N82FD2WX
In this file Col A represents time. I am trying to take time average in the group of 4.
I mean B1 is the time average of A1:A4, B2 is avg of A5:A8, B3 is avg of A9:A12 and so on.
How can I do the same...