Finding Used and Unused Numbers

G

Glenn

Hi,

I have a worksheet that contains 2 columns of data:

Column A contains a list of all available numbers to use.

Column C contains a list of all numbers that have been used.

I need to be able to find out the following:

Which numbers from Column A haven't been used.

Which numbers from Column A have been used twice.

Thanks!
 
F

Frank Kabel

Hi
in column B enter the following formula
=COUNTIF($C$1:$C$1000;A1)
and copy down
 
Top