Delete records/rows in column 2 from column 1?

[mangpfang]

Is there an easy way to delete the matching records/rows in column 2 from column 1 (or visa versa)?

Example.....

Have this in spreadsheet:

C1 C2

1 1
2 2
3
4
5
6

Would like excel to delete all of the fields in the rows in Column 2 from Column 1, thus making Column 1 look like this:

C1

3
4
5
6

Thank you so much for your time. Have a great day.

[Richard Buttrey]

Hi,

One non VBA approach would be to use a third helper column to test for identical values in cols. 1 & 2, then filter on the helper column and delete the filtered rows.

i.e. with

Please Login or Register  to view this content.

copy C1 down and filter for the word 'Delete', select all filtered rows and delete them. Then finally turn off the filter.

HTH

[mangpfang]

That is awesome. That gives me exactly what I need. Thank you so much!

[mangpfang]

Is there a way to do this if the columns do not match up?

Example:

A B C
1 6 Keep
2 1 Delete
3 7 Keep
4 8 Keep
5 9 Keep

Thank you so much for your time.

[Richard Buttrey]

Hi,

Yes, just use

Please Login or Register  to view this content.

change the $A:$5 range to suit your data.

Regards