deleting same rows in two columns

[osmanoca]

hello dear mrexcel lovers.

i have two columns data (A-B)

there some same data in same rows of two column like below:

A B
book book
lesson learn
pencil school
school school
book reading
lesson lesson


i want to delete same rows in A nd B . result must be like below:
lesson learn
pencil school
book reading


please help.

thanks very much

 

[JackDanIce]

In column C, enter formula:

=--(A1=B1)

Drag the formula to the last row
Filter for values of 1
Delete those rows
Remove filter and delete column C

Test on a copy of your data if unsure

 

[osmanoca]

Thank you very much dear JackDanIce . it solved.

thanks , god also helps you in your life...

In column C, enter formula:

=--(A1=B1)

Drag the formula to the last row
Filter for values of 1
Delete those rows
Remove filter and delete column C

Test on a copy of your data if unsure

 

[JackDanIce]

You're welcome