Hello to all,
I have two sheets, namely 'Company 1' and 'Company 2'. Each sheet has a column (F), namely 'ship number'. Company 1 has 12,500 rows and Company 2 has 350 rows. I would like to check if any of the ship numbers in company 2 are in company 1. If a ship number exists in Company 1, then I would like to highlight that row in Company 1 or least the column/cell, but the row would be really nice. I would then like to filter the results somehow. Many thanks.
Regards
JDS_916