Forum Thread: Extracting Data from a Spreadsheet Which Are Use Repeatedly Against a Column Value

I have data in a Spreadsheet from 2 Project Locations. Each Project Locations Has Different Suppliers - Some Have Unique Suppliers Whereas Some Suppliers Supply Commonly to Both Locations. I Want to Identify Those Suppliers Which Are Common to Both Locations.

Example see attached picture