Checking cell for Number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have about 200 numbers in column A. I would like to enter any number in
Column B. In column C I would like, it to show if the number is used or free.

can this be done with a if statement?


Thanks
 
Try...

=IF(COUNTIF($A$1:$A$200,B1),"Used","Free")

If you have a list of numbers in Column B that you'd like to check,
enter the above formula in C1, and copy and paste the formula to your
other cells in Column C.

Hope this helps!
 
Perfect

Thank you

Domenic said:
Try...

=IF(COUNTIF($A$1:$A$200,B1),"Used","Free")

If you have a list of numbers in Column B that you'd like to check,
enter the above formula in C1, and copy and paste the formula to your
other cells in Column C.

Hope this helps!
Click to expand...
 
Back
Top