Conditionally delete entire rows based on certain values in column A, B, C

primala

New Member
Joined
May 31, 2012
Messages
39
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
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

svkroy

Board Regular
Joined
Sep 12, 2009
Messages
178
Hi,
Looks like some random journals............The easiest would be to make a pivot with customer id as row labels and debit & credits as the values. Why do you need to delete rows ?

A mismatch in debit and credit can always be highlighted using a calculated field in the same pivot.
 

primala

New Member
Joined
May 31, 2012
Messages
39
Dear svkroy,

In practice I have to overview more than 300 rows within a file. The line pair of debit and credit of one transaction could separated far away, it makes me to search over manually line by line. And for one account 111200317, at least it has 100 files of charges in/out that I have to analyze, and in the end I have to make a report based on every single line transaction which involving account 111200317.

I'm not sure that PivotTable could help in this case. Anyway thanks for your advice and attention.

Regards
 

Watch MrExcel Video

Forum statistics

Threads
1,109,461
Messages
5,528,932
Members
409,847
Latest member
Foster034
Top