LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Reconciliation


Hi,

I would appreciate any suggestions how to create a macro that delete
the rows with the same value in column A and the sum of values i
column B equal to zero.

Example:
Column A Column B
AAA 50
BBB 100
AAA -50

I was thinking of using the worksheet function SumIf, but am not sur
how exactly to do that.

Thanks.
Eduar

--
Eduar
-----------------------------------------------------------------------
Eduard's Profile: http://www.excelforum.com/member.php...fo&userid=2680
View this thread: http://www.excelforum.com/showthread.php?threadid=40057

 
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
Reconciliation osaka78 Excel Discussion (Misc queries) 1 February 24th 10 03:12 PM
How can I formulate a reconciliation? Gorilla Show Excel Discussion (Misc queries) 2 March 11th 08 12:07 AM
Stock Reconciliation rajeev Excel Worksheet Functions 1 May 16th 05 10:02 AM
Bank reconciliation Nadeem Shafiullah Excel Programming 1 October 26th 04 03:45 AM
reconciliation shaharul Excel Programming 1 August 27th 03 01:10 PM


All times are GMT +1. The time now is 07:29 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"