LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Neo Neo is offline
external usenet poster
 
Posts: 7
Default Help deleting equal credits and debit columns

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining Text from 2 Columns into 1 then Deleting the 2 Columns sleepindogg Excel Worksheet Functions 5 September 19th 08 12:36 AM
Formula to FIND DUPLICATE DEBIT AND CREDITS Joe H. Excel Worksheet Functions 2 August 24th 07 07:08 PM
Deleting rows that are equal amts but different signs Dolphinv4 Excel Discussion (Misc queries) 1 December 28th 06 02:46 PM
columns into debit amounts roadrunner Excel Discussion (Misc queries) 3 August 22nd 06 09:24 AM
What query isused to add up the credits until it matches a debit? Apache Excel Worksheet Functions 0 May 13th 05 02:39 AM


All times are GMT +1. The time now is 01:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"