A better way

  • Thread starter Thread starter Tim
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random selection of records based on specifc value 5
Lookup Macro 5
Cut and Paste Macro 1
Is there a better way? 7
Count number of like occurences across all worksheet within workbo 12
select and paste data based on creteria on previous cells 2
Visible rows copy to different worksheet 5
Range to Variable for Sort 2

Back
Top