Finding Used and Unused Numbers

  • Thread starter Thread starter Glenn
  • Start date Start date
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!
 
Hi
in column B enter the following formula
=COUNTIF($C$1:$C$1000;A1)
and copy down
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lookup and return column number 2
Excel lookup across entire workbook 1
MACRO RUN random percentage and copy of column values 1
Unique #s in column, need multiple associated numbers in columns 5
SUMIF using date ranges & referencing account numbers 1
Vlookup or similar 7
Changing column reference for number of formulas at once 1
How do I use "column" function to get the column number of the firstcell matching criteria? 1

Back
Top