Closed Thread
Results 1 to 3 of 3

Checking cell for Number

  1. #1
    Lee
    Guest

    Checking cell for Number

    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

  2. #2
    Domenic
    Guest

    Re: Checking cell for Number

    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!

    In article <[email protected]>,
    Lee <[email protected]> wrote:

    > 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


  3. #3
    Lee
    Guest

    Re: Checking cell for Number

    Perfect

    Thank you

    "Domenic" wrote:

    > 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!
    >
    > In article <[email protected]>,
    > Lee <[email protected]> wrote:
    >
    > > 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

    >


Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1