Assigning Data groups

malbrianloy

New Member
Joined
Aug 18, 2011
Messages
4
Hello Everyone!

I have a question about assigning groups to a data set. The idea is that one of my store room managers can print out an all products list with lot in inventory at the beginning of the year and then assign weeks to that data up to 24 weeks. Then each week they will print out that weeks inventory list and perform a cycle count. Here is an example:


Item Lot Qty Week
aaaaa 111 5
112 2
bbbbb 234 3
233 4
231 6
ccccc 456 2
543 2
455 2
653 4

In this example, lets say its only 3 weeks, and we are grouping by 10 so I want excel to do this:

Item Lot Qty Week
aaaaa 111 5 week1
112 2 week1
bbbbb 234 3 week1
233 4 week2
231 2 week2
ccccc 456 2 week2
543 2 week2
455 6 week3
653 4 week3

In the real life example I have about 2000 items, and if I want 24 weeks, that means I would want groups of 83. Hope someone can help!
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Watch MrExcel Video

Forum statistics

Threads
1,123,323
Messages
5,600,954
Members
414,417
Latest member
Nobu

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

Which adblocker are you using?

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
Top