Hello, I have a problem that I don't know how to solve. I have two almost identical excel-documents. A few of the numbers are new in one of the documents. What I want to do is to compare the documents and in some way highlight the new numbers that are not present in both of the documents (Either by having them in color, extract them to a third document or some other clever solution). Is this possible to do? And if it is, do you know how to do this? Johan Sundelius

You could use another workbook or spare worksheet and subtract the contents of each cell in one workbook from the corresponding cell in the other workbook. Then all cells with a calculated value not equal to zero relate to the new numbers. eg =[workbook1.xls]sheet1!a1-[workbook2.xls]sheet1!a1 Not a clever solution but it should work, it would good to use conditional formatting to change the colour but you cannot refer to another workbook/sheet. Cliff

Provided each row has a unique reference, I would use =if(isna(match(A2,sheet2!$A:$A,0))=true,1,0) And the same for the second sheet. Apply a filter to exclude all the 0s, and bob's your uncle. Two lists of "unique" entries.