Multiple Data Validation and Over all Data

[abdulads]

Looking to get Dependent Data Validation

Issues I am facing is 1) Business Unit is reflecting as Operation and also Division is Operations so the Name is same i cannot input multiple Data Validation
2) I am not sure how to do Overall selection.

Please find Sample Sheet and Result sheet has all the instructions.

Thank you in advace.

Looking for outtput as

Sample.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Analysis
2
3
4	Division:					*would need Overall & List of all the Divisions (Refer to Data Tab, Column F) * No duplicate values
5
6	Business Unit:					*would need Overall & List of all the Business Units, based on the selected Division (Refer to Data Tab, Column E) *based on division selection, only the roll up business units need to be auto populated. *No duplicate values
7
8	Country:					*would need all the countries displayed & no duplicates (Refer Data Tab, Column D)
9
10
11	Write formula from Column B17 onwards (level count metrics should be calculated based on the above 3 selection options).
12
13
14	Count by Level:
15
16	Level	#
17	Staff
18	Manager
19	Senior Manager
20	Associate Director
21	Managing Director
22	Partner
23	Total
24
Result

Data

Book1
	A	B	C	D	E	F
1	ID	Name	Level Name	Country	Business Unit	Division
2	1	Test 1	Senior Manager	UNITED STATES	Eng -1	Engineering
3	3	Test 3	Partner	UNITED STATES	Eng -1	Engineering
4	6	Test 6	Managing Director	UNITED STATES	Eng -1	Engineering
5	9	Test 9	Senior Manager	UNITED STATES	Eng -1	Engineering
6	55	Test 55	Staff	UNITED STATES	Eng -2	Engineering
7	56	Test 56	Staff	UNITED STATES	Eng -2	Engineering
8	269	Test 269	Associate Director	NETHERLANDS	Eng - 3	Engineering
9	271	Test 271	Manager	INDIA	Eng - 3	Engineering
10	272	Test 272	Manager	CANADA	Eng - 3	Engineering
11	62	Test 62	Manager	UNITED STATES	Fin - 1	Finance
12	296	Test 296	Associate Director	UNITED STATES	Fin - 1	Finance
13	357	Test 357	Senior Manager	CANADA	Fin - 1	Finance
14	7000	Test 7000	Manager	JAPAN	Fin - 2	Finance
15	7042	Test 7042	Staff	INDIA	Fin - 2	Finance
16	7065	Test 7065	Managing Director	UNITED STATES	Fin - 2	Finance
17	199	Test 199	Manager	UNITED STATES	IT - A	IT
18	227	Test 227	Manager	UNITED STATES	IT - A	IT
19	286	Test 286	Managing Director	CANADA	IT - A	IT
20	6901	Test 6901	Staff	INDIA	IT - B	IT
21	6991	Test 6991	Staff	INDIA	IT - B	IT
22	7031	Test 7031	Staff	INDIA	IT - B	IT
23	7046	Test 7046	Staff	UNITED STATES	IT - B	IT
24	1041	Test 1041	Manager	UNITED STATES	Operations	Operations
25	1049	Test 1049	Senior Manager	INDIA	Operations	Operations
26	1062	Test 1062	Manager	UNITED STATES	Operations	Operations
27	1089	Test 1089	Staff	INDIA	Operations	Operations
28	1099	Test 1099	Partner	GERMANY	Operations	Operations
29	19	Test 19	Staff	UNITED STATES	A	Product
30	20	Test 20	Senior Manager	UNITED STATES	A	Product
31	34	Test 34	Senior Manager	UNITED STATES	A	Product
32	1950	Test 1950	Partner	UNITED STATES	C	Product
33	1957	Test 1957	Staff	INDIA	C	Product
34	1960	Test 1960	Manager	INDIA	C	Product
35	1962	Test 1962	Staff	INDIA	C	Product
36	1876	Test 1876	Staff	INDIA	B	Product
37	1877	Test 1877	Staff	INDIA	B	Product
38	1891	Test 1891	Manager	INDIA	B	Product
39	2	Test 2	Partner	UNITED STATES	Team A	Sales
40	4	Test 4	Associate Director	UNITED STATES	Team A	Sales
41	5	Test 5	Partner	UNITED STATES	Team A	Sales
42	1738	Test 1738	Staff	INDIA	Team C	Sales
43	1739	Test 1739	Staff	INDIA	Team C	Sales
44	1740	Test 1740	Staff	INDIA	Team C	Sales
45	1609	Test 1609	Manager	UNITED STATES	Team B	Sales
46	1615	Test 1615	Senior Manager	UNITED STATES	Team B	Sales
47	1618	Test 1618	Partner	UNITED KINGDOM	Team B	Sales
Sheet1

 

[JW00]

Hi, before I answer, with the Countries drop down, do you want all countries all of the time, it seems like that may cause conflicts as those records won't be available in your table unless you select Overall in the other two drop downs, the countries can be based on your previous two selections?