Hi,
Thank you for the response and your suggestion. Your assumption related to the feedback always happening after the donation is correct.
However, this doesnt work as expected when the donation date is within 10 days of NOT the immediate previous row, but one before that.
As an example, consider rows 11 and 13 on the spreadsheet I've attached. The feedback for the donation in row #11 was sent on 2/1/2009. The donation date on row #13 is 2/2/2009. However, the indicator now shows No, since there is an intermediate entry on row #12, which does not meet this validation criteria.
This is not an unlikely scenario, and tends to happen quite often where the feedback for an earlier donation is sent after the feedback for a more recent donation (this depends on a number of factors such as which non-profit organization the donation was made to, how soon they utilize the funds and send feedback etc.).
Any suggestions?
Bookmarks