+ Reply to Thread
Results 1 to 2 of 2

Array Frequency formula - data array increase by 1

  1. #1
    Registered User
    Join Date
    Bucharest, Romania
    MS-Off Ver

    Array Frequency formula - data array increase by 1


    I have approx. 100 rows with numbers which I'd need arranged in (same) bins categories.
    In a new sheet I used the frequency formula to look at the first row and return in an array in a column the distribution in bins. It worked for the first row from the source data but now I'd like that when I drag the formula to the next column, the data array in the frequency formula to move to the next row of the data source and return the distribution by bins.
    Is it possible, can you please help with this one? Or is there any other way I can do such a bin arrangement ?

    Removed the .png
    Excel file attached - I have column B with product names: A,B, C, etc, each product with it's carachteristics displayed horizontally. I am trying to place the charact. in the bins shown in column T (bins are not the same length) and then drag the formula across all the way to cover from U to P. I did it for product A in column U. Can you please help?
    Attachment 520471
    Thanks a lot!
    Attached Files Attached Files
    Last edited by mikyi_ro; 05-29-2017 at 04:24 PM. Reason: updated fileS

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    Steamboat Springs
    MS-Off Ver
    MS Office 365

    Re: Array Frequency formula - data array increase by 1

    Hi and welcome to the forum

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count unique company names (Frequency Array Formula)
    By Carrol in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-02-2016, 11:18 AM
  2. Help with Frequency/Array Formula!
    By henryBukowski in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-20-2014, 10:41 AM
  3. Array looping, increase speed of array macro
    By techrcn in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-27-2013, 05:33 AM
  4. using frequency function not including blank cells in the data array
    By alliugiv in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-12-2013, 08:53 AM
  5. Replies: 1
    Last Post: 08-31-2005, 02:05 PM

Tags for this Thread


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