Countifs not working for second criteria

  • I have the following code that is supposed to remove account numbers, from either the "Master" Sheet or the Sheet "41Days" based on the account number and the date. If I remove the second criteria in the countifs, this code runs fine but deletes the duplicate account numbers from only one sheet or the other depending on if I comment out one of the two "If isarray" statements. I need to be able to delete the account numbers from the correct sheet based on if it's a duplicate and it meets the date requirements.



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!