IF THEN

[Guest]

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.

 

[Bob Phillips]

I think we need some idea of how the data is structured.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Sorry, the information is in a row format.

Acc $ Acc Dt 1st $ 1st Dt 2nd $ 2nd Dt 3rd $
3rd Dt
4500 8/21/02 9800 1/10/03 7800 5/30/04 4500
10/1/06

I need to know how many days it was before the report equaled $4500 (the
date that the number was finally reported correctly) and the average amount
the numbers were off, until the report was finally done correctly.

Thanks.