Deleting a set of entries based on sum of entries in the set

I have used Power Query, called Get and Transform Data in your version of Excel and found on the Data Tab.

I loaded your table into the PQ editor. Data-->Get & Transform Data-->From Table or Range

I then applied the following Mcode

Please Login or Register  to view this content.

I then made a duplicate of the original table in PQ and created a merge of each table to the other (a left outer join)

Here is the Mcode for that next section

Please Login or Register  to view this content.

Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

- Follow this link to learn how to install Power Query in Excel 2010 / 2013.

- Follow this link for an introduction to Power Query functionality.

- Follow this link for a video which demonstrates how to use Power Query code provided.

regn,
What's happen to your previous thread.
https://www.excelforum.com/excel-pro...ntire-set.html

vba

Please Login or Register  to view this content.

Thanks for the hint! Yes, I thought this could be done with PQ. There are actually many ways to accoplish this, the easiest one is probably is through SUMIFS funciton. You can just insert this function in each line (with the code as criteria) and delete all the rows that return 0. I'm just learning VBA, and this is why I wonder how this can be done with more advanced code.

@Jindon

The requirements were a little bit different this time, so I created a new thread.

Thanks again! This works!

Please don't quote whole posts -- it's just clutter.*If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding. I have removed the quotes this time.