Good morning,
I have a pivot table with phone call and email audit scores. I want to automatically find the top five scores per month. So I can use an =LARGE sum for the number, but then finding the associated label is causing me issues.
I can't use a vlookup to the value because the values can be identical. I found a YouTube video which shows a workaround, but I've done something wrong as my formula is finding the wrong label for the value.
I've attached a spreadsheet with my pivot which shows the label in column A (e.g. Greeting), and the score for email and phone in columns B and C. The two adjacent tables show the top five issues for phone and email (or should be), so next month I can refresh my pivot and hey presto! The tables update.
Please help!
Jemma
Bookmarks