Hello
I have a problem that i can`t solve. I have a matrix of people that are educated in a different technique. For every person that is educated in the matrix he receives a number 1. The person that is not educated receives a number 0.
So what i want is to have is a formula to insert in data validation in drop down list and in the drop down list there must be only that persons who are educated (they have the number 1). Please see the attachment
=IF(AND($O$9="Method1";$C$5:$C$6=1);B5:B6;IF(AND($O$9="method2";$D$5:$D$6=1);B5:B6;""))
I do get the correct answer for the 1. and 2. person but the problem is when the formula get to the person with a 0; the formula is false and i get a blank answer.
How do i make a formula to dynamically look for number 1 and the it gives me all the person who have the number 1.
Thank you guys very much for your help.
Kind regards, Pavel
Bookmarks