Multiple logic

[visshukaka]

I have multiple units operating in multiple countries. I use same accounting software for all countries. Sometime software does not provide exact information. Also for data validation, purposes I need to know how many new accounts created this month. Say in column A I have # of a unit, Col B is location of unit, col. C is account code, col. D is amount.
Now some of the countries may not have balances in some of the accounts. I want to remove duplicate accounts which have “0” value. If I use excel’s remove duplicate function it may remove account which might have values; but my intention is to only keep those unique accounts having value in it so that I will have better representation of accounts.
Also, since I work say in Japan hence I do not need Japan accounts in the list or say I don’t care even if they have values in it or not.

Can anyone help me to do this in one logic or macro? I am not visual basic person so I do not know much about coding, but I am okay with Excel formulas. The reason I asked for macro is b/c I need to do this process every first Monday of the month so this is kind of repetitive task.


Attaching a sample file. If not interested in sample file then here is what in the file –

Column A – Unit / Company Number
Column B – Country of operation
Column C- General Ledger account number
Column D – Amounts
Each company have several accounts with same number but each company may not have amounts in each account.