Hi,
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 ?
Update:
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!
Bookmarks