and she wants to know who used the vehicle the most by month. I couldn’t think of an easy way to do this with worksheet functions, so I resorted to a pivot table.
With Date on the left, Driver across the top, and Count of Driver in the data area, I grouped the date on month (right click – group and show detail – group).
Finally, I went to Field Settings for the Driver field (the one across the top) and showed the Top 1
I went back to the data and changed a few ‘Mikes’ to ‘Tammys’ in May and here’s what that looks like. With a sufficiently large data set, it seems like showing Top 1 wouldn’t make any difference because it would just show all the columns anyway.
Better ways to get this data?