+ Reply to Thread
Results 1 to 2 of 2

Frequency formula

  1. #1
    Curious
    Guest

    Frequency formula

    Thanks for any help you may be able to provide.

    Yesterday there was a post about counting unique values.

    The reply had a link to a frequency formula -

    http://tinyurl.com/5rloz

    The OP never replied back so it's unknown if that formula
    worked.

    I'm always interested in learning new techniques so I
    played around with this formula.

    The problem is this formula doesn't work. I copied the
    formula to a worksheet (had to remove some junk that got
    embedded from the Google archives) but when I tried it I
    got an error message that said "not enough arguments for
    this function".

    The formula doesn't include the Bins_Array argument for
    the Frequency function. So I added that argument as an
    empty range -

    Z1:Z5 with nothing in that range.

    According to Excel help, If bins_array contains no values,
    FREQUENCY returns the number of elements in data_array.

    Well, that did not work. I kept getting results of 0.

    Can anyone help me understand that formula and how it
    works?

    Thank you

  2. #2
    Jason Morin
    Guest

    Re: Frequency formula

    It works. If you want a file with some examples, send me
    an e-mail. Change OPPOSITEOFCOLD to you know what.

    Jason

    >-----Original Message-----
    >Thanks for any help you may be able to provide.
    >
    >Yesterday there was a post about counting unique values.
    >
    >The reply had a link to a frequency formula -
    >
    >http://tinyurl.com/5rloz
    >
    >The OP never replied back so it's unknown if that

    formula
    >worked.
    >
    >I'm always interested in learning new techniques so I
    >played around with this formula.
    >
    >The problem is this formula doesn't work. I copied the
    >formula to a worksheet (had to remove some junk that got
    >embedded from the Google archives) but when I tried it I
    >got an error message that said "not enough arguments for
    >this function".
    >
    >The formula doesn't include the Bins_Array argument for
    >the Frequency function. So I added that argument as an
    >empty range -
    >
    >Z1:Z5 with nothing in that range.
    >
    >According to Excel help, If bins_array contains no

    values,
    >FREQUENCY returns the number of elements in data_array.
    >
    >Well, that did not work. I kept getting results of 0.
    >
    >Can anyone help me understand that formula and how it
    >works?
    >
    >Thank you
    >.
    >


+ Reply to 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