Hello,
Im trying to randomly assign products to a certain location randomly. Locations consist of 3 products and are either for an A, B or C product. Therefore it is not possible to have any duplictates. How can I randomly assign products to a certain location so that every product is stored and that there are not any duplicates?
Is there a solutions, VBA or just with formulas, to model this in Excel?
Regards,
Willem
Im trying to randomly assign products to a certain location randomly. Locations consist of 3 products and are either for an A, B or C product. Therefore it is not possible to have any duplictates. How can I randomly assign products to a certain location so that every product is stored and that there are not any duplicates?
Is there a solutions, VBA or just with formulas, to model this in Excel?
Regards,
Willem