Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Vermilion, Ohio, USA
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How many times a number appears in an array (2002)

    how can i find out how many times a certain number appears in an array <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How many times a number appears in an array (2002)

    Say your array is A1:A37, and the "certain number" is in cell B1. The formula =COUNTIF(A1:A37,B1) will return the number of times the value in B1 occurs in A1:A37.

    Does this do what you want? If not, please post back with more details.

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Vermilion, Ohio, USA
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How many times a number appears in an array (2002)

    That's it. Thanks a lot.

Posting Permissions

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