Find common part number amongst various suppiers

  • I have a workbook with 5 sheets for my suppliers. In the M-Column I have their part numbers.

    Some suppliers have one part number for the item and sometimes it is 2 part numbers and sometimes it is 5 part number for the item, it varies. It depends on the supplier.


    Typically there is a matching part number or numbers amongst the various suppliers. I want to know what those matching common part number is for all of the suppliers.


    Can this be done?

    AMPC Test.xlsx

  • Quote

    I want to know what those matching common part number is for all of the suppliers.

    Please give an example of what this means using the data you supplied. I am not sure what you are asking and what you wish to be displayed. Smaller samples with a before and after scenario would seriously help to get your a bona fide solution.