E
expect_ed
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
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