I
instereo911 via OfficeKB.com
Good morning,
I have a workbook and my goal is to see when a number is no longer on the
sheet.
My workbook looks like this
A B
1 05/01/2007 25235
2 05/01/2007 68325
3 05/01/2007 78932
4 05/02/2007 68325
5 05/02/2007 11123
6 05/03/2007 99823
so on and so forth
I need to get an average of how many numbers were closed within 1 day, how
many were closed within 2 days, etc.
In this instance, I would say 5 total numbers, 4 closed within 1 day, 1
closed within 2 days
Hopefully this is possible... I have a sheet with a months worth of numbers.
Thanks again everyone.
I have a workbook and my goal is to see when a number is no longer on the
sheet.
My workbook looks like this
A B
1 05/01/2007 25235
2 05/01/2007 68325
3 05/01/2007 78932
4 05/02/2007 68325
5 05/02/2007 11123
6 05/03/2007 99823
so on and so forth
I need to get an average of how many numbers were closed within 1 day, how
many were closed within 2 days, etc.
In this instance, I would say 5 total numbers, 4 closed within 1 day, 1
closed within 2 days
Hopefully this is possible... I have a sheet with a months worth of numbers.
Thanks again everyone.