buckets

Racking my brain on this one... creating a table of 1-10 buckets to show the average of values that fall in those buckets. The buckets are simply a min as the lowest, max as the highest, and the rest is equally distributed between the min and max. The issue is that when I also do a count of...

Hello, I have a range of percentages from -6% to 8% that each correspond to a dollar amount. I need to group these percentages into different buckets,about 8 or so. Once grouped, I want the buckets on the ends to hold less dollaramounts while the buckets in the middle will hold more. Is there...

Hi All I want to divide a number by 3 and distribute it in whole numbers. I found examples online using a bucket and tennis balls but haven't been able to translate it. A1=22 tennis balls, and B,C,D are buckets of tennis distributed into whole numbers B1=8 C1=7 D1=7 Your help is greatly...

Hello, i have a spreadsheet that i would like to add a column to "E" and name it BUCKETS as the header. then i want it to copy a formula down from e2 down to lastrow that related to the information in column D The issue im running into is that the row numbers are not changing in the formula...

I have a column of values - I'm looking to write a formula that counts how many values fall into each of the following buckets <500, 501 - 1000, 1001 - 2500, 2501 - 5000, 5001 - 10000, 10001 - 50000, >50000 Can you help me, please?

Hi there, I have a model that is identical across 30 sheets. Each sheet rolls up to 1 of 3 different buckets. Using a mapping table of each tab name and the bucket it relates to, I'd like to summarize the 3 buckets into 3 separate tabs (identical to the model that's being used in the 30...

Hi, I'm trying to create a pivot table based on Power Pivot where the rows show two things. Ranking Buckets and Amount Buckets, so something like this. <tbody> Ranking Measure1 Measure 2 etc 1-10 11-25 26-50 etc </tbody> <tbody> Amount Measure1 Measure 2 etc 1-50k...

Hi, I'm looking for a formula that in the first phase would return an array of aggregated order intake values based on available weekly order intake. The aggregation needs to group 2,3,4,5 or more weeks (definable by the user) into bigger chunks and preferably return the result as an array. In...

Hi Guys, I am wondering if anyone could assist with finding a formula to group various percentages into the different percentage groups. For example "Less than 0%", 0-5%,5-10% and, "More than 15%" Thanks