Forum Discussion

Copper Contributor

Jul 25, 2019

Extract shared values between two columns

Hi everyone, I am trying to extract shared values between two columns. I found a post on another website that has a formula to use, but I am struggling to apply it to my dataset. Below is the fo...

excel

Formulas and Functions

Kodipady

Iron Contributor

Jul 25, 2019

MGreenfield

It would help if you could upload your worksheet with some sample data in it. Please remove/mask any sensitive data before upload.

MGreenfield

Copper Contributor

Jul 25, 2019

Kodipady

Attached is the document I'm working on. Thanks for your help!

Excel Help.xlsx13 KB

SergeiBaklan
Diamond Contributor
Jul 25, 2019
MGreenfield

In A2 and B2 there are errors returned. If remove, formula in C2 works.
Excel Help (1).xlsx24 KB
- MGreenfield
  Copper Contributor
  Jul 25, 2019
  Amazing! Thank you so much for your help!! SergeiBaklan
  - SergeiBaklan
    Diamond Contributor
    Jul 25, 2019
    MGreenfield , you are welcome