Mass deletion of select records

[neilnet]

Hello geniuses!

I have two sheets.

Sheet 1 contains 120k rows and 1 column of mixed text data of two types (we'll call them type A and type B)

Sheet 2 contains 13k rows and 1 column of type B data.

I want to delete all of the data in sheet 2 (i.e. B data) from Sheet 1, so that sheet 1 will just include type A data.

Is this straightforward? I'm using Excel 2008 for Mac.

Very many thanks!

Best,
Neil

[Palmetto]

In Sheet1, in the column of choice, you could use a simple countif function to determine if "B-data" has a matching value on sheet2, then filter this column and delete visible rows where a match was found.

Example:
In Sheet1, cell F1: =COUNTIF(Sheet2!$A$1:$A$13000,A1)>0

The formula will return a true or false value. Filter on true values and delete the rows, then remove the filter.

[neilnet]

Thank you kindly!

To further highlight my cluelessness can you tell me how I filter the true data?

V. much appreciated!

[Palmetto]

I don't know what you mean by filter the true data. That is what the helper cells are for.
Use the formula, select the helper column, apply auto filter to show only true values, delete all visible rows after applying the filter, then turn the filter off.

Try this on a back up copy to make sure you get the results you want.