200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
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
A charge is not cleared while column D is blank. Therefore a statement may be generated in another column (column E as you suggest) based upon whether column D is blank or not.
[E2] =IF($D2="","Not cleared","Cleared")The strings may be replaced with messages best suited to your needs, including "" which would show a blank cell.
Edit 25 Oct 2018 ===============================
As an alternative, you might show the unclearded amount using the same basic method and formula.
=IF($D2="",$C2,"")Of course, you could generate a total of the uncleared items at the bottom of the page using the SUM() function. This total would change when a date is entered somewhere in column D and the amount shown in column E is thereby reduced.