comparing numbers

[Pam]

Is there a way you can compare two list of numbers
contained in two separate worksheets and determine what
numbers are not in each of the two spreadsheets?

 

[Bob Phillips]

Pam,

In Sheet1 cell B1 (assuming the numbers are in A)

=IF(COUNTIF(Sheet2!A:A,A1)>0,"Duplicated in Sheet2","")

and similarly on Sheet 2 cell B1

=IF(COUNTIF(Sheet1!A:A,A1)>0,"Duplicated in Sheet1","")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[GerryK]

With numbers in Column A Sheet1 and Numbers in Column B
Sheet 2 (I've set to 5 for this example).
Try this:
=IF(ISNA(MATCH(A1,Sheet2!$B$1:$B$5,0)),"Not Found","Found")

 

[John Tjia]

If they are exactly the same format, you can copy one to a new
worksheet, and then copy the other one on top of the first one, using
the Edit, Paste Special, Subtract. The identical numbers will zero
out, showing you the ones that are not identical.

If the numbers have formulas, use Edit, Paste Special, Values for the
first copying and then Edit, Paste Special, Values and Subtract for
the second.