Compile separate spreadsheet from 3 sheets showing non repeated items only

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post

COUNTIF is the simplest way.

On the sheet to show uniques you use 2 additional columns to do a countif against another sheet. In other words if Sheet1 is the sheet we want a list of uniques and we are looking at sheet 2 and sheet3...

Sheet 1 would have a column for a COUNTIF looking at sheet2 and another for looking at sheet3

Essentially a count > 0 means it exists on the other sheet, 0 it does not. You can simply filter the results down and paste them to a new sheet (or copy the sheet and then remove the non 0 results from it). Rinse and repeat the same process for each sheet having the COUNIF's looking at the other 2.

Be aware any means of comparison you use like this is looking for exact matches. IE: "ProductA" and "Product A" and " ProductA" and " Product A " are all different. As people we may know they are the same but as far as Excel is concerned they are not exactly the same. If your data has variations like this you will need to clean it up (called normalizing your data) before the formulas can be accurate. This process can be easy or very difficult deepening on how much your data varies.

Without a sample its hard to give exact advice