I have a column that lists all candidates qualifications and I would like to search for candidates that matches ONLY a list of qualifications I search for.
for instance if I list 3 different types of qualifications - it must ONLY list candidates who has all 3 qualifications and not list candidates who has only 2 or 1 of the qualifications I list.
I need the list to show me candidates that has all 3 qualifications. how do I do this, I tried combo boxes but it still shows me candidates that has only 2 or the 3 qualifications I am looking for.