Re: Using the EXACT Function

I don't think EXACT will work. Try a VLOOKUP:

in D1, type

=VLOOKUP(C1,$A$1:$A$15034,1,FALSE)

in E1, type

=IF(ISNA(D1),C1,"")

and replicate both formulas down to Row 25000.

The numbers in Column E will then contain your unused numbers. Copy
that column, Paste Special (Values), and then you can delete the
formulas in Column D.

Mark Lincoln

On Apr 19, 2:42 pm, "Jim Berglund" <jazz...@xxxxxxx> wrote:
I've created a simple spread***.

Column A is a list of 15034 used Work Order reference numbers (many values
are missing); Column C is a complete list (25,000 numbers).

I want to get a separate list of unused numbers, but can't get the EXACT
function to work. ( I believe it should place a TRUE value in column D when
the numbers match.)

I've used:
=OR(EXACT(C1,$A$1:$A$15034)), which I replicated down the column.

Please help...
Thanks,
Jim Berglund


.

Quantcast