Remove rows in large excel file

Pau905

New Member
Joined
Nov 10, 2020
Messages
16
Office Version
  1. 365
Hello all,

I have another question... I would like to remove all rows dependent on the values in two columns.

If column "Header4" includes "X" I would like to remove that row
If column "Header5" includes "Y" I would like to remove that row

The excel sheet contains 100 columns and 300000 rows. What is the fastest way to do this?

The Query for this is: (But I do not have the data in Access, only in one excel sheet)
DELETE *
FROM Table1
WHERE
Table1.Header4<>'XX'
AND Table1.Header5<>'YY'

/P
 

Attachments

  • Remove rows fast.jpg
    Remove rows fast.jpg
    138 KB · Views: 7

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Pau905

New Member
Joined
Nov 10, 2020
Messages
16
Office Version
  1. 365
Sorry! The above is the opposite what I want! The query is correct! And this picture!
 

Attachments

  • Remove rows fast.jpg
    Remove rows fast.jpg
    146.5 KB · Views: 0

Watch MrExcel Video

Forum statistics

Threads
1,127,318
Messages
5,623,974
Members
416,002
Latest member
Neshx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top