Jul 16 2018
09:21 PM
- last edited on
Jul 31 2018
08:45 AM
by
TechCommunityAP
Jul 16 2018
09:21 PM
- last edited on
Jul 31 2018
08:45 AM
by
TechCommunityAP
Jul 17 2018 05:08 AM
Jul 18 2018 07:59 PM
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
Jul 19 2018 01:40 AM
I used PowerQuery (Datatab of ribbon, "From table" button) to create the table on the second worksheet (see attached).
Aug 23 2018 03:37 PM
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