CODEWITHSUNDEEP
excelexcel-formulaexcel-2016
Gatewarden
Gatewarden

Reputation: 393

Compare two columns in excel with different lengths

I have two columns in Excel, with different length. They contain links to SharePoint sites.

I need to make a comparison, so that in column C, I would like to get all the links that exist in column A and not B.

In column D I would like to get all the links that exist in column B and not A.

To clarify, in the C and D column I want the link values, and not any true, false or 0 or 1.

As it's links I don't see how any test data would help to be posted here but in case you need it, leave a comment and I'll put something together as I cant post the company links here.

Upvotes: 0

Views: 2336

Answers (1)

JoeJam
JoeJam

Reputation: 371

You can use =IF(ISERROR(INDEX($B$1:$B$39,MATCH($A1,$B$1:$B$39,0))),A1,""). This will return all of the values that are exclusively in Column A. You can adjust the formula to return only values that are in Column B.

Upvotes: 1

Related Questions