I am trying to build a spreadsheet that can auto generate cycle codes for our inventory, we have over 5,000 items. It has to be broken out into 3 categories (A,B,C) I have this working. Then create a random number based on what category the parts are in. Example A is a random number between 1-13, B is between 1-26 & C is between 1-50. Then combine the Class & week number. I can get this to work but I have to manually change the formulas at the changes in class, Plus I would like one formula to do all of this where I am using 3.
Please help.
Bookmarks