+ Reply to Thread
Results 1 to 3 of 3

2 dimensional array and freq function?

  1. #1
    Registered User
    Join Date
    06-13-2004
    Posts
    8

    Question 2 dimensional array and freq function?

    Hey all,

    A newbie hoping you can help with a problem I am having regarding applying the frequency function to a 2 dimensional array.

    I have my 2 dimensional array populated with random numbers and I want to apply the frequency function to the array but I have no idea how it can be done.

    Is it possible to do so, or can it only be applied to actual ranges on a spreadsheet? If it is not possible can someone please suggest another approach?

    (The reason I am using an array is because I want to use more rows than is allowed on a spreadsheet. ie more than 65536 rows)

    Any help greatly appreciated.

    Thanks

  2. #2
    Tom Ogilvy
    Guest

    Re: 2 dimensional array and freq function?

    From Help:

    FREQUENCY(data_array,bins_array)

    Data_array is an array of or reference to a set of values for which you
    want to count frequencies. If data_array contains no values, FREQUENCY
    returns an array of zeros.

    However I doubt it will work with an array with more than 65536 rows and may
    not work with that many depending on version.

    You might have to roll your own.

    --
    Regards,
    Tom Ogilvy


    "dabith" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Hey all,
    >
    > A newbie hoping you can help with a problem I am having regarding
    > applying the frequency function to a 2 dimensional array.
    >
    > I have my 2 dimensional array populated with random numbers and I want
    > to apply the frequency function to the array but I have no idea how it
    > can be done.
    >
    > Is it possible to do so, or can it only be applied to actual ranges on
    > a spreadsheet? If it is not possible can someone please suggest another
    > approach?
    >
    > (The reason I am using an array is because I want to use more rows than
    > is allowed on a spreadsheet. ie more than 65536 rows)
    >
    > Any help greatly appreciated.
    >
    > Thanks
    >
    >
    > --
    > dabith
    > ------------------------------------------------------------------------
    > dabith's Profile:

    http://www.excelforum.com/member.php...o&userid=10566
    > View this thread: http://www.excelforum.com/showthread...hreadid=472314
    >




  3. #3
    Registered User
    Join Date
    06-13-2004
    Posts
    8
    Thanks for the info Tom.

    I guess I'll try manipulating the data using sql.

+ 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