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

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