Urgent Help needed

[jamilm]

Gurus,

i have the below worksheet. what i need help is the statistical selection that for each group there is equal chance of selection of cities based on the Ethnicity. each group need to have diverse selection meaning at least one from each athnicity and when in the last groups when some ethnicities are out of number then it is okay to have two or more from each ethnicity for example Asian is more and therefore in the later groups if there are two asian or three in a group then it is okay.

Excel 2012
	A	B	C	D	E
1	Current City	Ethnicity		Groups	needed sulotion Current City
2	Shanghai	Black		A-1	Baghdad
3	So Paulo	Asian		A-1	Riyadh
4	Bogot	Hispanic		A-1	Guangzhou
5	Jaipur	American Indian		A-1	Johannesburg
6	Delhi	Hispanic		A-1	Tianjin
7	Baghdad	White		A-2
8	Hong Kong	Asian		A-2
9	Ahmedabad	Hispanic		A-2
10	Riyadh	Asian		A-2
11	Guangzhou	Black		A-2
12	Johannesburg	American Indian		A-3
13	New York City	White		A-3
14	Bangkok	American Indian		A-3
15	Alexandria	American Indian		A-3
16	London	Asian		A-3
17	Hyderabad	White		A-4
18	Jakarta	Asian		A-4
19	Tianjin	Black		A-4
20	Yokohama	White		A-4
21	Los Angeles	Asian		A-4
22	Singapore	White		A-5
23	Rio de Janeiro	Asian		A-5
24	Cairo	Hispanic		A-5
25	Lahore	Hispanic		A-5
26	Kolkata	Hispanic		A-5
27	Busan	White		A-6
28	Kanpur	Asian		A-6
29	Nairobi	American Indian		A-6
30	Tehran	Asian		A-6
31	Seoul	American Indian		A-6
32	Santiago	Hispanic		A-7
33	Mexico City	White		A-7
34	Moscow	Asian		A-7
35	Karachi	Black		A-7
36	Abidjan	Asian		A-7
37	Ankara	Black		A-8
38	Shenyang	Hispanic		A-8
39	Tokyo	Asian		A-8
40	Lima	Asian		A-8
41	Saint Petersburg	White		A-8
42	Ho Chi Minh City	Asian		A-9
43	Jeddah	Hispanic		A-9
44	Berlin	Asian		A-9
45	Chennai	Hispanic		A-9
46	Yangon	White		A-9
47	Chongqing	White		A-10
48	Beijing	Hispanic		A-10
49	Wuhan	Asian		A-10
50	Mumbai	Asian		A-10
51	Buenos Aires	American Indian		A-10
52	Durban	Asian		A-11
53	Dhaka	White		A-11
54	Istanbul	Black		A-11
55	Kinshasa	American Indian		A-11
56	Pyongyang	White		A-11
57	Lagos	Asian		A-12
58	Cape Town	Asian		A-12
59	Pune	Asian		A-12
60	Madrid	American Indian		A-12
61	Bangalore	Asian		A-12
Sheet1

 

[jamilm]

please let me know, if my question is not clear?