Help with creating some sort of filter please!

[Andystevenson]

Hi all,

I am well and truly stumped!
I hoping somebody will be able to help me with this as I have spent days trying to make sense of it but I am not getting anywhere.

I want to be able to easily filter a location to decide out a number of people who would it take the shortest amount of time to travel to that location.
I have managed to do this by creating a pivot table and then creating a formula for the closest person. I have also added a slicer to easily filter the location.
To me that's the easy bit.
The next thing I want to do is to be able to filter out certain people that could attend that location. So if there was a person that was closest to that location but didn't have a certain skill I could remove them so they don't appear in the filter for that location. So somehow I would like to filter by a skill then filter by a location to show the people that could travel to that location and the closest person. That probably sounds easy but I just cant work it out. Does anyone have any ideas.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Help with creating some sort of filter please!
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.