Unique values one one sheet against others

[scaffdog845]

All,

Is there a formula that will compare numeric values from C:C on sheet4 against the same range in SHEET1:SHEET4 and return only the unique values that exist on sheet4?

Thanks

[teylyn]

Care to post a (small) sample workbook?

[scaffdog845]

I'm attaching a relatively blank workbook just to demonstrate the request. The actual workbook this will be used in has several columns of data with several hundreds of rows on each sheet. Sheets 1:3 are listings of scheduled work orders with 6 digit numbers in C:C of each sheet. Sheet4 is completed work throughout the month. The purpose is top find the WO numbers that were completed without being scheduled on the first 3 sheets.

[teylyn]

For a one-off solution try this:

On Sheet4 in cell D1 put this formula and copy down to the last entry on your list on Sheet4

=IF(COUNTIF(Sheet1!C:C,Sheet4!C1)+COUNTIF(Sheet2!C:C,Sheet4!C1)+COUNTIF(Sheet3!C:C,Sheet4!C1)=0,Sheet4!C1,"")

Next select column D and sort ascending.

Will that do for you?

[scaffdog845]

Thanks for the help teylyn. Worked perfectly! have a great week.