I have an excel spreadsheet using three columns (B, C, D) that tracks credit card charges.
The vendors are in Column B, Charges in Column C and The Date Cleared in Column D.
Charges are entered in B & C after charges are made.
The Dates Cleared are entered in D after they are cleared.
I would like to be able to have a Column E that tracks all uncleared charges.
I would like to use either a macro or excel formula to do this.
Thanks