Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I have a spreadsheet with debit and credit columns and I need to cancel out rows that equal the debit and credit columns. Example: A B 1 Credit: Debit: 2 15 0 3 15 0 4 10 0 5 0 12 6 12 0 7 13 0 8 14 0 9 0 15 10 0 15 In this scenario, I'm deleting rows 2,3,5,6,9 and 10 because they cancel out each other in the debit and credit columns. Now I'm doing this manually because I cannot come up with a formula that will delete the ROWS that match the DEBIT AND CREDIT COLUMNS. I really would appreciate it if somone could help me with a formula to delete only the rows that match DEBIT AND CREDIT. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
Formula to FIND DUPLICATE DEBIT AND CREDITS | Excel Worksheet Functions | |||
Deleting rows that are equal amts but different signs | Excel Discussion (Misc queries) | |||
columns into debit amounts | Excel Discussion (Misc queries) | |||
What query isused to add up the credits until it matches a debit? | Excel Worksheet Functions |