Jan 23 2019 10:02 AM
I am trying to separate some cells from a bank exported file in excel and need some help from someone much smarter than I am.
This is what I have: All the numbers in column C are together as credits and debits. I need to move the debits to column D.
A | B | C | D |
Date | Description | Credit | Debit |
12/26/18 | Withdrawal ACH VERIZON WIRELESS | 360.93 | |
12/26/18 | Withdrawal ACH Bear River | 319.28 | |
12/26/18 | Deposit ACH Square Inc | 88.36 | |
12/26/18 | Deposit ACH Square Inc | 17.65 |
This is what I need it to look like: I need a formula that puts column C and moves it to column
D if the text in column B has the word "deposit". If it has the word "withdrawal" then it stays
in column C.
A | B | C | D |
Date | Description | Credit | Debit |
12/26/18 | Withdrawal ACH VERIZON WIRELESS | 360.93 | |
12/26/18 | Withdrawal ACH Bear River | 319.28 | |
12/26/18 | Deposit ACH Square Inc | 88.36 | |
12/26/18 | Deposit ACH Square Inc | 17.65 |
Thank you for your help.
Jan 24 2019 02:50 AM
Jan 24 2019 06:23 AM
Rich,
Thank you so much, that worked like a charm.