Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200707/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating TAT (Turn Around Time) | Excel Worksheet Functions | |||
How do I turn SCRL off? | Excel Discussion (Misc queries) | |||
Turn Off New UI | New Users to Excel | |||
WHY DOES 1E4 TURN INTO 1.00 E + 04? THANKS | Excel Discussion (Misc queries) | |||
How do i turn it off | Excel Discussion (Misc queries) |