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

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!

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.