# grouping algorithm

1. ### Grouping Data by summing values and criteria

Hi There, I wonder if someone can help me? I have a series of data (~700 rows, 5 columns) that I am looking to allocate into 5 groups using a random function and based on a series of rules / criteria that I would like to apply. I wondering if there is a simple formula that I can apply to the...
2. ### Dividing rows into groups based on two parameters

Dear all, I have the following problem: I need to divide the rows below into groups, based on two criteria. e.g. The sum of Balls <= 10.000 & the sum of Bucket <= 5 the order of the rows cannot change. Is there an (easy) way to let excel determine these groups? the result in the row...
3. ### Automate the grouping function within a Pivot table based on wildcard search

I have a two sets of data from two different subsidiaries that serve the same market. The newer subsidiary "bought" customers from the old one, but the old subsidiary still services the market with those products that still remain outside of the capability of the new subsidiary. Easy, right...
4. ### Data sort grouping by first 4 digits

Hi all, wonder if someone may be able to assist? I'm trying to sort a selection of data into groups (2 cols, 1st is P-No, 2nd is Qty) based on the first four digits of the P-No and then tally the groups Qty (so I have the total Qty for any given product group) but short of sorting the data by...
5. ### Need brains to develop algorithm

I am doing some study in which I want to group records on certain parameters say weight, volume, Date of Mfg. I want to pack the materials in boxes with above details with following constraints. 1. Total weight in the container should <= X 2. Total Volume in the Container should <=Y 3. Can...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back