Posted by Ken McLane on March 03, 2000 10:20 AM
I am fairly new to this, and I have a couple of problems.
1. I have a list of products, columns of: MANUFACTURER, MODEL, PART #,
DESCRIPTION, COST and PRICE. I am looking for a way to check the model
column to see if it contains certain words, and if so, cut the entire
row and paste it to another sheet. There are three or four different
words I need to key on. These words are always at the right end of the
column. I have about 4000 rows of data.
2. After that, I need to integrate what is left with an existing list,
comparing the two and eliminating duplicate rows. I have been doing this
by hand. I basically need to add the new items off the list and discard
the items that are redundant.
I have put a lot of the information on your site into practice and it
has saved me tons of work. I have tried to apply the techniques I see
here to this but I am not experiencing a lot of success. Thank you for
any help you can offer.
I am using Excel 97.