delete rows where there are 3 or 4 cells with values > 0

**Beekster** · 07-25-2013, 04:11 AM

Hi

I have 4 long columns of data and I want to detete all rows that contain either 3 or 4 values > 0. These could appear in any one of the columns so all 4 need to be examined to decide whether to delete a row. After deletion I presumably need to count back 1 row and then continue.

Many thanks for any help.

Beekster

**XOR LX** · 07-25-2013, 04:31 AM

Hi,

Assuming that the four columns to which you refer are A, B, C and D and that your data begins in row 2, in cell E2 enter this formula and copy down as required:

=IF(COUNTIF($A2:$D2,">0")>2,"DELETE","")

Filter this new column for DELETE and delete all rows.

Regards

**ragulduy** · 07-25-2013, 04:33 AM

Maybe:

Please Login or Register  to view this content.

Assuming your columns are A to D

**Beekster** · 07-25-2013, 04:38 AM

Beautiful!
Many thanks

**Beekster** · 07-25-2013, 04:49 AM

equally effective as the other macro solution posted
Many thanks

**snb** · 07-25-2013, 05:06 AM

or:

Please Login or Register  to view this content.

delete rows where there are 3 or 4 cells with values > 0

LinkBack

Thread Tools

Rate This Thread

Display

delete rows where there are 3 or 4 cells with values > 0

Re: delete rows where there are 3 or 4 cells with values > 0

Re: delete rows where there are 3 or 4 cells with values > 0

Re: delete rows where there are 3 or 4 cells with values > 0

Re: delete rows where there are 3 or 4 cells with values > 0

Re: delete rows where there are 3 or 4 cells with values > 0

Thread Information

Users Browsing this Thread

Similar Threads

Delete rows if values match in a block of cells

Scan rows for duplicate column values, then add rows together and delete unused rows.

Delete rows that have columns with duplicate values in different cells

How to delete all rows if any cells in the row contain certain values.

Delete rows with numeric values, leave rows with text

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions