Herr is the easy way

1) Copy sheet 1 to sheet 2
2) Add an index number in column E. Put 1 in E1, put 2 in E2 and pull down
sheet to get a column of sequential numbers. I'm going to sort and this is
so we can get the order back to the original order when done.
3) put tis formula in cell F1 =C1=D1 This will put either True or
False in colun F
4) Select column F and Copy. then use PasteSpecial with Value selected to
convert formula to Values
5) Select data to be sorted. then go to menu Data - Sort and select column
F as only key
6) Delete Rows with TRUE.
7) sort again using column E to return the data to its original order.

This seems like a lot of steps but it is very quick.

"expect_ed" wrote:

Is there a way to combine functions to eliminate rows from a list based on
criteria?
I have column C and D which have 500 rows of data. In about 10% of the rows
the data in C does not match the data in D. I want to reproduce the list in
sheet 2 but only disply the rows that have non-matching data:

Sheet 1 Sheet 2
Col C Col D Becomes Col C Col D
12 12 tom david
tom david 8 0
3 3 table chair
8 0
jim jim
table chair

I know I could use a data column to compare the columns and then use vlookup
to get the next non-matching row, but I'm looking for a way to do it with
just formulas in sheet 2 and now have to create a compare column.

Thanks in advance for any assistance.
ed