Formula to Pull out #s if they appear multiple times across different organizations

acondie

Hi,

I'm trying to create a formula that will recognize and pull out any material #s that appear for different plants and make a new column with those material #s. I don't care so much if the material # appears multiple times for one plant, I only care if it appears for more than one plant.

For example, Material # 1 appears for A22, H45, and D53 so I would want this number to get pulled out. I wouldn't need any of the other material #s to get pulled out. I hope that makes sense.

Any help would be appreciated!

Thanks!

Paul Newcome

Do you need just one instance of the number? What do you plan on doing with this data once pulled out?