I have a pivot table I am using to pull information from audits I have been conducting for the past few months. Each week I filter the pivot table by area and match the row and column to determine which specific questions are the most deficient. I am sure that there is an easier way to do this so that I don't spend so much time each week. Ideally I would like to create some sort of code or formula that would pull the top 10 deficient questions from each area and reference its destination, for example G5 is the most deficient question followed by I4. Here is what my pivot table looks like, currently the area is not filtered so that you can see the compiled results of every area.