AnsweredAssumed Answered

Common Data

Question asked by smacleod on Apr 20, 2015
Latest reply on Apr 20, 2015 by BruceRobertson

I need to pull out the common data between three fields.

I am not sure how to make a calculation to do that.

I have three fields with lists, and need to find the value(s) that match all three.

 

Field 1:

100

104

 

Field 2:

104

105

 

Field 3:

104

109

 

I need to have a calculation return "104"

 

Thanks!

Outcomes