Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reconciliation | Excel Discussion (Misc queries) | |||
How can I formulate a reconciliation? | Excel Discussion (Misc queries) | |||
Stock Reconciliation | Excel Worksheet Functions | |||
Bank reconciliation | Excel Programming | |||
reconciliation | Excel Programming |