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
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

svkroy

Board Regular
Joined
Sep 12, 2009
Messages
179
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,651
Messages
5,838,576
Members
430,557
Latest member
MK15

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top