Divide some soldiers into 2 or 3 platoons.

[KlausW]

Hello

Can anyone help with this challenge. I need to divide some soldiers into 2 or 3 platoons.

The number of the platoons stand in E1.

In column A from A2 down are the heights of soldiers, in column B from B2 down are their names. in column C from C2 down is their gender, in column D from D2 down is their job / occupation.

They must be distributed on 2 or 3 sheets.

So that there are about the same number of people in height, the same number of men and woman, and if there are more with the same job / occupation, and about the same number in each platoon.

All help will be appreciated

Best regards

Klaus W

 

[Herakles]

Hello

Can anyone help with this challenge. I need to divide some soldiers into 2 or 3 platoons.

The number of the platoons stand in E1.

In column A from A2 down are the heights of soldiers, in column B from B2 down are their names. in column C from C2 down is their gender, in column D from D2 down is their job / occupation.

They must be distributed on 2 or 3 sheets.

So that there are about the same number of people in height, the same number of men and woman, and if there are more with the same job / occupation, and about the same number in each platoon.

All help will be appreciated

Best regards

Klaus W

Can you please use Xl2BB to submit your data instead of people having to replicate it for themsalves?

 

[KlausW]

Hi Herakles like this ?

Delings.xlsx
	A	B	C	D
1	Height	Name	Gender	job / occupation
Ark1

Delings.xlsx
	G
8
1 delingen

Delings.xlsx
	A	B	C	D	E	F
1	Height	Name	Gender	job / occupation	Delinger
2 delingen

 

[MARK858]

Hi Klaus, you need to select the range that you need posted before you click the Mini Sheet button (only select about 20 rows if it represents the information needed)

 

[KlausW]

Ok thanks

 

[KlausW]

This way ?

Delings.xlsx
	A	B	C	D
1	Height	Name	Gender	job / occupation
2	158	Aleksander	M	Kok
3	158	Frederikke	K	Ufaglært
4	158	Carl-Emil	M	HHX
5	162	Oliver	K	HTX
6	164	Isabella	M	STX
7	164	Jean	M	STX
8	165	Cille	M	HF
9	166	Sofie	K	Kok
10	168	Emma	K	STX
11	169	Inge	M	HTX
12	169	Katrine	K	STX
13	170	Andreas	M	Bager
14	174	Stefan	M	STX
15	176	Thomas	K	STX
16	177	Joachim	K	Ubefaren skibsassistent
17	178	Mikkel	M	Smed
18	178	Mia	M	HHX
19	179	Marinella	M	HHX
Ark1

Cell Formulas
Range	Formula
C2:C19	C2	=IF(E2=1,"K",IF(E2=2,"M",IF(E2="","")))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A9:B9,D9,D33	Expression	=$H$17="TPK"	text	NO
A13:B13,D13	Expression	=$H$21="TPK"	text	NO
A12:B12,D12	Expression	=$H$20="TPK"	text	NO
A11:B11,D11	Expression	=$H$19="TPK"	text	NO
A3:B3,D3,A25:B25,D25	Expression	=$H$11="TPK"	text	NO
A2:D2,C3:C40	Expression	=$H$10="TPK"	text	NO
A4:B4,D4	Expression	=$H$12="TPK"	text	NO
A5:B5,D5	Expression	=$H$13="TPK"	text	NO
A6:B6,D6	Expression	=$H$14="TPK"	text	NO
A7:B7,D7,A27:B27,D27,A40:B40,D40	Expression	=$H$15="TPK"	text	NO
A8:B8,D8	Expression	=$H$16="TPK"	text	NO
A10:B10,D10	Expression	=$H$18="TPK"	text	NO
A14:B14,D14,A34:B34,D34	Expression	=$H$22="TPK"	text	NO
A15:B15,D15	Expression	=$H$23="TPK"	text	NO
A16:B16,D16,A36:B36,D36	Expression	=$H$24="TPK"	text	NO
A17:B17,D17,A37:B37,D37	Expression	=$H$25="TPK"	text	NO
A18:B18,D18,A29:B29,D29	Expression	=$H$26="TPK"	text	NO
A19:B19,D19,A28:B28,D28	Expression	=$H$27="TPK"	text	NO

Delings.xlsx
	A	B	C	D
1	Height	Name	Gender	job / occupation
2	162	Oliver	M	HTX
3	182	Freja	K	STX
4	177	Joachim	M	Ubefaren skibsassistent
5	206	Katrine	K	Ufaglært
6	158	Aleksander	M	Kok
7	158	Frederikke	K	Ufaglært
8	192	Nichlas	M	Elektriker
9	178	Mia	K	HHX
1 delingen

Cell Formulas
Range	Formula
C9	C9	=IF(E9=1,"K",IF(E9=2,"M",IF(E9="","")))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C3:C9	Expression	=$H$10="TPK"	text	NO
A9:B9,D9	Expression	=$H$23="TPK"	text	NO
D8	Expression	=$H$20="TPK"	text	NO
A7:B7,D7	Expression	=#REFERENCE!="TPK"	text	NO
A5:B5,D5	Expression	=$H$24="TPK"	text	NO
A4:B4,D4	Expression	=$H$16="TPK"	text	NO
A3:B3,D3	Expression	=$H$13="TPK"	text	NO
A2:D2	Expression	=$H$10="TPK"	text	NO

Delings.xlsx
	A	B	C	D
1	Height	Name	Gender	job / occupation
2	158	Carl-Emil	M	HHX
3	165	Cille	K	HF
4	181	Frida	K	STX
5	164	Isabella	K	STX
6	180	Mads	M	EUX Smed
7	186	Noah	M	Sabbatår
8	202	Sahra	K	Kok
9	194	Snorre	M	Tømrer
2 delingen

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D9	Expression	=#REFERENCE!="TPK"	text	NO
D8	Expression	=$H$12="TPK"	text	NO
A6:B6,D6	Expression	=$H$8="TPK"	text	NO
A4:B4,D4	Expression	=$H$19="TPK"	text	NO
A3:B3,D3	Expression	=$H$12="TPK"	text	NO
A2:B2,D2	Expression	=$H$9="TPK"	text	NO
C2:C9	Expression	=#REFERENCE!="TPK"	text	NO

 

[KlausW]

I can see there is some ref. errors in the formula