I have control numbers in Col E and Debit value in Col F & credit balances in Col E
Where the control numbers are the same in Col E values in col F - the values in Col G = zero for the same control number then these rows must be deleted
I am looking for a macro to do this
Your assistance in this regard is most appreciated
See sample data below
Where the control numbers are the same in Col E values in col F - the values in Col G = zero for the same control number then these rows must be deleted
I am looking for a macro to do this
Your assistance in this regard is most appreciated
See sample data below
Excel Workbook | |||||
---|---|---|---|---|---|
E | F | G | |||
1 | Control | Debit Balance | Credit Bal | ||
2 | 13/0002 | 12625.1 | |||
3 | 13/0002 | 12625.1 | |||
4 | 18/006 | 19186.52 | |||
5 | 18/006 | 100 | |||
6 | 18/006 | 5173.92 | |||
7 | 18/006 | 10847.18 | |||
8 | 18/006 | 9965.02 | |||
9 | 18/006 | 38550 | |||
10 | 18/006 | 1711.8 | |||
11 | 18/006 | 98159.54 | |||
12 | 13/0008 | 277903 | |||
13 | 13/0008 | 293844.7 | |||
14 | |||||
15 | |||||
Sheet1 |