Guys,
I have some data of transferring the amount of materials, involving 2 to 15 account numbers. For example :
right now I'm evaluating account number # 111200317, I have to know the detail of single charged into that account, both for transfer in (debit) or transfer out (credit).
Column A --> contains of account number
Column B --> contains of debit amount
Column C --> contains of credit amount
A1 = 111200317 B1= 300,000
A2 = 111000239 C2= (300,000)
A3 = 111101415 B3 = 500,000
A4 = 111000239 C4 = (500,000)
A5 = 111000239 B5 = 75,000
A6 = 111200317 C6 = (1,000,000)
A7 = 111001415 C7 = (75,000)
A8 = 111001415 B8 = 1,000,000
How to delete entire rows, with the conditions below :
- If cell value in column A is not 111200317 but if another rows are related to account number 111200317 should not be deleted.
In the above illustration :
Rows 1, 2, 6, 8 should stay and not deleted
Rows 3, 4, 5, 7 should be deleted
I know is really complicated, but I hardly believe that you have a better solution. I keep my finger crossed. Thank in advance
Regards
I have some data of transferring the amount of materials, involving 2 to 15 account numbers. For example :
right now I'm evaluating account number # 111200317, I have to know the detail of single charged into that account, both for transfer in (debit) or transfer out (credit).
Column A --> contains of account number
Column B --> contains of debit amount
Column C --> contains of credit amount
A1 = 111200317 B1= 300,000
A2 = 111000239 C2= (300,000)
A3 = 111101415 B3 = 500,000
A4 = 111000239 C4 = (500,000)
A5 = 111000239 B5 = 75,000
A6 = 111200317 C6 = (1,000,000)
A7 = 111001415 C7 = (75,000)
A8 = 111001415 B8 = 1,000,000
How to delete entire rows, with the conditions below :
- If cell value in column A is not 111200317 but if another rows are related to account number 111200317 should not be deleted.
In the above illustration :
Rows 1, 2, 6, 8 should stay and not deleted
Rows 3, 4, 5, 7 should be deleted
I know is really complicated, but I hardly believe that you have a better solution. I keep my finger crossed. Thank in advance
Regards