Hi, I am new here and would like some help

[AM05]

hi there everyone, i was hoping for some help here.

I have 13 departments and 121 employees and want to assign them departments (which have fixed spots) for a month randomize department for the given employees , I have been doing this manually and would like to use excel to automate the process so that I would have time to do other tasks,

thank you in advance for your help

 

[igold]

Hi AM05, welcome to the MrExcel Forum.

There are plenty of people who would like to help you. Help us help you by posting a representative sample of your data (real or fictitious) the way it is now (befrore) and how you would like the data to look after the solution (Formulas or Macros). It would great if you used XL2BB as that is the easiest for all parties. Good luck.

 

[AM05]

i have uploaded a file i am not sure what formula to use to shuffle the list for my use

and thank you for your response, I appreciate the help

 

[AM05]

#	Names	Current Department	New Department	Note
1​	James	Logistics		want to randomize the departments for a few people or everyone sometimes a complete shuffle
2​	Robert	Logistics
3​	John	Logistics
4​	Michael	Logistics
5​	David	Logistics
6​	William	Quality Assurance
7​	Richard	Quality Assurance
8​	Joseph	Quality Assurance
9​	Thomas	Quality Assurance
10​	Charles	Quality Assurance
11​	Christopher	Quality Assurance
12​	Daniel	Quality Assurance						Departments	Total Employee need	Note
13​	Matthew	Quality Assurance						Logistics	5​	these numbers can be chnaged according to the need of the business
14​	Anthony	Quality Assurance						Quality Assurance	20​
15​	Mark	Quality Assurance						Production	50​
16​	Donald	Quality Assurance						Re-Packing	25​
17​	Steven	Quality Assurance
18​	Paul	Quality Assurance
19​	Andrew	Quality Assurance
20​	Joshua	Quality Assurance
21​	Kenneth	Quality Assurance
22​	Kevin	Quality Assurance
23​	Brian	Quality Assurance
24​	George	Quality Assurance
25​	Timothy	Quality Assurance
26​	Ronald	Re-Packing
27​	Edward	Re-Packing
28​	Jason	Re-Packing
29​	Jeffrey	Re-Packing
30​	Ryan	Re-Packing
31​	Jacob	Re-Packing
32​	Gary	Re-Packing
33​	Nicholas	Re-Packing
34​	Eric	Re-Packing
35​	Jonathan	Re-Packing
36​	Stephen	Re-Packing
37​	Larry	Re-Packing
38​	Justin	Re-Packing
39​	Scott	Re-Packing
40​	Brandon	Re-Packing
41​	Benjamin	Re-Packing
42​	Samuel	Re-Packing
43​	Gregory	Re-Packing
44​	Alexander	Re-Packing
45​	Frank	Re-Packing
46​	Patrick	Re-Packing
47​	Raymond	Re-Packing
48​	Jack	Re-Packing
49​	Dennis	Re-Packing
50​	Jerry	Re-Packing
51​	Tyler	Production
52​	Aaron	Production
53​	Jose	Production
54​	Adam	Production
55​	Nathan	Production
56​	Henry	Production
57​	Douglas	Production
58​	Zachary	Production
59​	Peter	Production
60​	Kyle	Production
61​	Ethan	Production
62​	Walter	Production
63​	Noah	Production
64​	Jeremy	Production
65​	Christian	Production
66​	Keith	Production
67​	Roger	Production
68​	Terry	Production
69​	Gerald	Production
70​	Harold	Production
71​	Sean	Production
72​	Austin	Production
73​	Carl	Production
74​	Arthur	Production
75​	Lawrence	Production
76​	Dylan	Production
77​	Jesse	Production
78​	Jordan	Production
79​	Bryan	Production
80​	Billy	Production
81​	Joe	Production
82​	Bruce	Production
83​	Gabriel	Production
84​	Logan	Production
85​	Albert	Production
86​	Willie	Production
87​	Alan	Production
88​	Juan	Production
89​	Wayne	Production
90​	Elijah	Production
91​	Randy	Production
92​	Roy	Production
93​	Vincent	Production
94​	Ralph	Production
95​	Eugene	Production
96​	Russell	Production
97​	Bobby	Production
98​	Mason	Production
99​	Philip	Production
100​	Louis	Production

 

[igold]

I am a little vague on exactly what you want to shuffle. That said, see if you can derive anything from here that might get you closer...

Randomize a List in Excel

This article teaches you how to randomize (shuffle) a list in Excel. For example, we want to randomize the list in column A below.

www.excel-easy.com

 

[AM05]

thank you for your response, that being said, what i am looking for is, i have a set amount of employee working for the company and i want to shuffle all the employees within all the departments.(i have finally understood how to use Xl2bb)

New Microsoft Excel Worksheet.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	#	Names	Current Department	New Department	Note
2	1	James	Logistics		want to randomize the departments for a few people or everyone sometimes a complete shuffle
3	2	Robert	Logistics
4	3	John	Logistics
5	4	Michael	Logistics
6	5	David	Logistics
7	6	William	Quality Assurance
8	7	Richard	Quality Assurance
9	8	Joseph	Quality Assurance
10	9	Thomas	Quality Assurance
11	10	Charles	Quality Assurance
12	11	Christopher	Quality Assurance
13	12	Daniel	Quality Assurance						Departments	Total Employee need	Note
14	13	Matthew	Quality Assurance						Logistics	5	these numbers can be chnaged according to the need of the business
15	14	Anthony	Quality Assurance						Quality Assurance	20
16	15	Mark	Quality Assurance						Production	50
17	16	Donald	Quality Assurance						Re-Packing	25
18	17	Steven	Quality Assurance
19	18	Paul	Quality Assurance
20	19	Andrew	Quality Assurance
21	20	Joshua	Quality Assurance
22	21	Kenneth	Quality Assurance
23	22	Kevin	Quality Assurance
24	23	Brian	Quality Assurance
25	24	George	Quality Assurance
26	25	Timothy	Quality Assurance
27	26	Ronald	Re-Packing
28	27	Edward	Re-Packing
29	28	Jason	Re-Packing
30	29	Jeffrey	Re-Packing
31	30	Ryan	Re-Packing
32	31	Jacob	Re-Packing
33	32	Gary	Re-Packing
34	33	Nicholas	Re-Packing
35	34	Eric	Re-Packing
36	35	Jonathan	Re-Packing
37	36	Stephen	Re-Packing
38	37	Larry	Re-Packing
39	38	Justin	Re-Packing
40	39	Scott	Re-Packing
41	40	Brandon	Re-Packing
42	41	Benjamin	Re-Packing
43	42	Samuel	Re-Packing
44	43	Gregory	Re-Packing
45	44	Alexander	Re-Packing
46	45	Frank	Re-Packing
47	46	Patrick	Re-Packing
48	47	Raymond	Re-Packing
49	48	Jack	Re-Packing
50	49	Dennis	Re-Packing
51	50	Jerry	Re-Packing
52	51	Tyler	Production
53	52	Aaron	Production
54	53	Jose	Production
55	54	Adam	Production
56	55	Nathan	Production
57	56	Henry	Production
58	57	Douglas	Production
59	58	Zachary	Production
60	59	Peter	Production
61	60	Kyle	Production
62	61	Ethan	Production
63	62	Walter	Production
64	63	Noah	Production
65	64	Jeremy	Production
66	65	Christian	Production
67	66	Keith	Production
68	67	Roger	Production
69	68	Terry	Production
70	69	Gerald	Production
71	70	Harold	Production
72	71	Sean	Production
73	72	Austin	Production
74	73	Carl	Production
75	74	Arthur	Production
76	75	Lawrence	Production
77	76	Dylan	Production
78	77	Jesse	Production
79	78	Jordan	Production
80	79	Bryan	Production
81	80	Billy	Production
82	81	Joe	Production
83	82	Bruce	Production
84	83	Gabriel	Production
85	84	Logan	Production
86	85	Albert	Production
87	86	Willie	Production
88	87	Alan	Production
89	88	Juan	Production
90	89	Wayne	Production
91	90	Elijah	Production
92	91	Randy	Production
93	92	Roy	Production
94	93	Vincent	Production
95	94	Ralph	Production
96	95	Eugene	Production
97	96	Russell	Production
98	97	Bobby	Production
99	98	Mason	Production
100	99	Philip	Production
101	100	Louis	Production
Sheet1

 

[AM05]

i want to change the department of the employee with any human interaction, all by the a formula, as i don't want to show favoritism to any employee and get blamed for play favorites

 

[AM05]

*without

 

[igold]

Did you look at the link I provided.