B
Bill
Hi, I have a large excel data worksheet which has the
basic look:
Item: PointA PointB PointC PointD PointE
#01 01-Feb 04-Feb 05-Feb 13-Feb 22-Feb
#02 03-Feb 06-Feb 10-Feb 15-Feb 27-Feb
#03 03-Feb 15-Feb 19-Feb 01-Mar 10-Mar
#04 15-Feb 22-Feb 28-Feb 01-Mar 12-Mar
#05 20-Feb 22-Feb 28-Feb 03-Mar 06-Mar
#06 24-Feb 28-Feb 11-Mar 12-Mar 14-Mar
#07 11-Mar 14-Mar 16-Mar 17-Mar 22-Mar
Its much larger.. but this gives a picture: Also the
dates are dd-mmm-yy and my data sheet contains about 2
years worth of data with more than 700 rows and 25 points
(Columns).
I am looking to evaluate the AVERAGES between
Points (by month..and in days) to see evaluate the
averages related... and place the results on another
worksheet. I am doing this manually... but was hoping
there was a faster way. Currently I am manually
calculating the days between points for each item. Then
sorting point "A" for all of Feb and then calculating the
Average for Feb - March Etc. so I can say for example:
In January-02 the Average time it took for (insert the
number of time Jan-02 appeared in Column B) an
average of 5.8 days as compared to June-03 we had the
volume (insert the number of times Jun-02 appears in
Column B) an average of 10.4 days .. to get from point A
to point B
Thank You in advance for
your time and advice! Bill
basic look:
Item: PointA PointB PointC PointD PointE
#01 01-Feb 04-Feb 05-Feb 13-Feb 22-Feb
#02 03-Feb 06-Feb 10-Feb 15-Feb 27-Feb
#03 03-Feb 15-Feb 19-Feb 01-Mar 10-Mar
#04 15-Feb 22-Feb 28-Feb 01-Mar 12-Mar
#05 20-Feb 22-Feb 28-Feb 03-Mar 06-Mar
#06 24-Feb 28-Feb 11-Mar 12-Mar 14-Mar
#07 11-Mar 14-Mar 16-Mar 17-Mar 22-Mar
Its much larger.. but this gives a picture: Also the
dates are dd-mmm-yy and my data sheet contains about 2
years worth of data with more than 700 rows and 25 points
(Columns).
I am looking to evaluate the AVERAGES between
Points (by month..and in days) to see evaluate the
averages related... and place the results on another
worksheet. I am doing this manually... but was hoping
there was a faster way. Currently I am manually
calculating the days between points for each item. Then
sorting point "A" for all of Feb and then calculating the
Average for Feb - March Etc. so I can say for example:
In January-02 the Average time it took for (insert the
number of time Jan-02 appeared in Column B) an
average of 5.8 days as compared to June-03 we had the
volume (insert the number of times Jun-02 appears in
Column B) an average of 10.4 days .. to get from point A
to point B
Thank You in advance for
your time and advice! Bill