Hi,
See CPearson Web look for Delete duplicate rows, passing the middle of the
page
http://www.cpearson.com/excel/deleting.htm
"MF" wrote:
I need to compare a column of 50,000 terms against a column of the 50 states
to remove any state names from the terms. Is this a formula or macros? How
would it be accomplished?
Ex.
Terms:
Furniture
Chairs Idaho
Desks
Desks in Alabama
Waterbeds
Florida Waterbed Store
State list (to remove):
Alabama
Arizona
Arkansas....