Jason,
You should be able to do this with a helper column. I assume you want to delete entire rows when you have a match.
1) in an empty column enter 1 in the cell of your first data row. Enter 2 in the second row. Select both cells and double click the fill handle (black square in lower right hand corner of selection). This should create a sequential list of numbers all the way to the bottom of your list. You will use this column to resort your data later.
2) In another empty column use the MATCH function to find customers in your list. This formula assumes the customer names start in A1 and the list of customers to delete are on a seperate sheet in column A.
=MATCH(A1,Sheet2!A:A,0)
You can enter this formula in your first row, adjusting the cell references for your sheet, and double click the fill handle to copy down.
3) Select the entire list and Sort on the match column. You can now delete the entire set of customers that matched your list. These will be anything with a number. All of the #N/A's mean that the name was not found.
4) Now you can resort on the first helper column to make sure everything is back in the orginal order.
5) Delete the two helper columns.
If you have any questions just post back.
Good Luck,
Mark Graesser
(e-mail address removed)
----- Jason White wrote: -----
OK, I have a huge customer list I need to clean up. I
cannot figure out how to find cells that match any cell
of a specified column.
basically I need to compare a worksheet to a list and
delete any cell on the worksheet that matches any cell in
the list.
I'm an Excel newbie so go easy on me.
Thanks!
