Hello everybody,
I have a huge data set from which I need to find and elaborate results.
In this example I need to identify people who have a combination of certain skills (value 0-5) and certifications(Yes if they have it). I have to cross match with lookup every time and I want to automate it.
Suppose I need to find all the people who have a certain skill level e.g. Excel skill level 4 or 5 and they must have Prince certification. I want to have a way, maybe with some automatic controls that give me a drop down list to select a skill and certification and then elaborate in a new sheet a table that helps me identify the people who have that combination. OR also a combination of skills with certain level.
Thanks a lot !!
Tavi
Bookmarks