A better way

T

Tim

I have about 700 unique stock numbers on one worksheet.
If any of these numbers appear in a column of about 8,000
records (on a different worksheet), I would like the row
deleted. I am doing this one number at a time, but know
there has to be a better way. Please help.

Thanks
 
F

Frank Kabel

Hi
one way:
- in your sheet with the 700 numbers use a helper column 8lets say
column B)
- enter the following formula in B1
=IF(COUNTIF('sheet2'!$A$1:$A$8000)>0,"X","")
- copy this down for all 700 rows
- now filter (goto 'Data - Filter - autofilter') all rows with an 'X'
in column B
- delete these filtered rows
- remove the filer
 
Top