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?