Hi I have 3 spreadsheets, all listing various products spanning from columns A to BC, with varying number of rows on each: Minimum 52 rows, maximum 366 rows.

On each sheet column B lists products, these products are repeated sometimes in each sheet.

I need to compile a separate spreadsheet from all 3 sheets showing only the products that are not repeated anywhere within the 3 sheets.

Any ideas? I've drawn a blank.

Thanks in advance