Duplicates between 2 rows

[jmaresca]

Hello everyone! I have something I am working on but its driving me a little bats at the moment and I am hoping someone can help.

I have a spreadsheet with two columns. Each column has a list of keywords in it. I am trying to compare column 2 against column 1 and place the unique keywords into Column 3. When I try doing this my way excel is not comparing exact keywords.

For example, if I have a keyword phrase in column 1 that is "unique bedroom layout ideas" and in column 2 there is a keyword phrase "bedroom layout ideas" excel seems to be calling these duplicates. Obviously the later part of the phrase is duplicated however these are in fact unique versions and I would like to place all of the uniques in that 3rd column based on what I just mentioned.

Any help would be greater appreciated. Thank you all in advance.

 

[gallen]

Hello and welcome,

How are you performing the task? Formulaic or VBA? Either way can you post what you have?

 

[jmaresca]

Hello gallen and thanks for your reply. I was using Conditional Formating >> Highlight Cells >> Duplicate Values. Here is the file with the phrases: https://ufile.io/ros112wy

 

[Fluff]

Hi & welcome to MrExcel.
How about

Sub jmaresca()
   Dim Ary As Variant
   Dim i As Long
   
   Ary = Range("A1").CurrentRegion.Value2
   With CreateObject("scripting.dictionary")
      For i = 2 To UBound(Ary)
         .Item(Ary(i, 1)) = Empty
         .Item(Ary(i, 2)) = Empty
      Next i
      Range("C2").Resize(.Count).Value = Application.Transpose(.Keys)
   End With
End Sub

 

[gallen]

Sadly my work's firewall won't allow me to view files. I'm confused how Conditional formatting can be used to to compare 2 columns and add unique to a 3rd. That is way beyond my skills.

With VBA I could have done in a few lines of code but using Conditional formatting will be a job for other experts. I'm sure they can help.

 

[jmaresca]

Sadly my work's firewall won't allow me to view files. I'm confused how Conditional formatting can be used to to compare 2 columns and add unique to a 3rd. That is way beyond my skills.

With VBA I could have done in a few lines of code but using Conditional formatting will be a job for other experts. I'm sure they can help.

It doesnt need to work by Conditional Formatting. This is just one of 2 ways I tried. Whatever gets the job done I think is best.

 

[Fluff]

Did you see my suggestion in post#4?