Data Validation with multiple criteria

[reynold]

Hello Friends,

This is my first post so please let me know if my query is not clear to understand.
I am novice user of excel.

I am creating data validation i.e. drop down list for the service "Spa"

1)Select Specialist Gender (Lets select Male)
2)Select Specialist (this should only show names of Spa specialist who are male)

I am struggling to populate the list, please help. Below are the two tables giving information on Specialist and their gender.

Hair Specialist	Make up Specialist	Spa Specialist	Pedicure Specialist
Sophia	Hannah	Robert	John
James	Michael	Anna	James

<tbody>
</tbody>

Male	Female
James	Sophia
John	Olivia
Robert	Hannah
Michael	Anna

<tbody>
</tbody>

 

[oldbrewer]

			speciality1	spa
			sex	male
			Count of name
			name	Total
			Robert	1
			Grand Total	1
name	sex	speciality1
James	male	hair
John	male	pedicure
Robert	male	spa
Michael	male	make up
Sophia	female	hair
Olivia	female	make up
Hannah	female	make up
Anna	female	spa
with a pivot table you enter spa and male
and it will list all names that match
the speciality and provider gender

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Peter_SSs]

Welcome to the MrExcel board!

You may also find this useful.