Hi,
i have a file where there are transactions that needs to be categorized with 4 possible outcome but needs to meet some conditions
1)
If col A contains: Deposits Credits AND contains in col B: Tfr Transfer Credit
Result categorize the item as = HOC IN
2)
If Col A contains: Withdrawals Debits Other AND in col B: Tfr Transfer Debit
Result categorize the item as = HOC OUT
3)
If col A contains: Deposits Credits AND DOES NOT CONTAIN in col B: Tfr Transfer Credit
Result categorize the item as = WIRES IN
4)
If Col A contains: Withdrawals Debits Other AND DOES NOT INCLUDE in col B: Tfr Transfer Debit
Result categorize the item as = WIRES OUT
I have attached a data for ease of work.
thanks
Kam
Bookmarks