W
watchtower
I need the formula to search column A:
If there are any matches in column A,
AND the amounts in column B are the same
AND the dates are within 30 days of each other in column C,
Result = Y.
Otherwise = “â€
Plan # Amount $ Rcvd. Date Paid Formula
Result
300531 2,500.00 1/15/2007 Y
300056 8,900.00 1/18/2007
300531 2,500.00 1/31/2007 Y
350011 4,800.00 1/31/2007
If there are any matches in column A,
AND the amounts in column B are the same
AND the dates are within 30 days of each other in column C,
Result = Y.
Otherwise = “â€
Plan # Amount $ Rcvd. Date Paid Formula
Result
300531 2,500.00 1/15/2007 Y
300056 8,900.00 1/18/2007
300531 2,500.00 1/31/2007 Y
350011 4,800.00 1/31/2007