Forum Discussion
Finding top 5-10 samples checked out within a date range (ability to change the date range)
I am working on a spreadsheet with a “recap” sheet to display the top 5-10 samples that have been checked out. I have been able to use the Large function to setup a top 5-10 successfully. I am now hav...
What does your data look like?
Have you tried using a pivot table? That has a top n option.
Have you tried using a pivot table? That has a top n option.
Hi Jan,
Here is a sample of the data. I have tried a pivot table and did not have any luck. I could be doing it incorrectly though.
-Taylor
I used PowerQuery (Datatab of ribbon, "From table" button) to create the table on the second worksheet (see attached).
Hi Jan,
Thank you. I am having issues with using the date range and being able to adjust the date range. The pivot table shows the highest 5 numbers within the entire spreadsheet rather than during the date range (7/23/2018 - 7/30/2018). Do you know how to include this in the formula or pivot table?
Thank you,
Taylor
