Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
In an array, I need to identify the total number of days and dollars out of
sync if specific conditions are not met. For instance, A report is due on X date but 3 reports later, the dollars were finally correct. I need to calculate the number of days it took to finally get the numbers correct and by how much the numbers were off. I have a spreadsheet with about 300 of these entries and it took anywhere from 2 to 6 reports to get the numbers correct. |