Remove records if same between column B & C 1

[YNOTU]

Hello all, I'm trying to find a way to first compare columns B and C in an excel workbook and if they contain the same data delete one instance of it on either column.

Is this even possible??

Thanks in advanced all...

​

 

[YNOTU]

if you can provide me a link where I could learn how to do it would work also.... Thanks

 

[TonyJollans]

Hi DECEMBER14TH,

In column D put the formula ..

[blue][tt] =IF(b1=c1,"",c1)[/tt][/blue]

(enter in D1 and copy down as far as your data in B and C)

Then copy column D and paste special > values to itself and delete column C

Or something along those lines

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[YNOTU]

Thanks Tony, that's did it.

One thing tho, for some reason when I type the formula in the cell the formula does not work in some cells and it simply sits there as if it were plain text and some other cells when I type the formula I don't see it and it works...

 

[YNOTU]

got it working now. Weird... oh well.