IF THEN
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.
|