Hi,

Try this formula:

=COUNTIF(Test.xls]Sheet1!$A$1:$A$6,A1)

Copy it down.
This formula returns 0 if the value in A1 is not found in the second sheet,
otherwise it return the number of times the number is found.

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"Roman" wrote:

Hi,

I have 2 different Excel files with data. There are Numbers in Column 1 in
both files, and names in Column 2. Other then writing VB script or buying a
third party product is there an easier way to:

Check to see what numbers in File 1 are not in File 2.

If not, I can copy past the worksheet into the same file to have 2
worksheets in 1 file. If I do this, what would the formula be to check this
and then output the numbers that are missing in column 1 between the 2
worksheets. To get fancy what if I wanted it to then tell me the name in
Column B for the missing numbers.

Thanks