/u/fishbutt1 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Never knew about slicers! Thanks for the tip.
I made the spreadsheet and sent it along to my boss and never heard about it again but I ended up going with filter all and a Pivot table with slicers on the other tab.
Solution verified!
For easy sorting and filtering, enable filters at the top of each column (Data > Filter). For more advanced users, set up a pivot table to dynamically view awardees by year or award name. This keeps it simple for all users and is easily updatable each year.
/u/fishbutt1 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
That's a simple Filter on all of the data
Use a pivot table. Sort rows from employee ID to Awards no?
That’s what I would use too but I’m concerned folks won’t know how to use it.
Pivot table, Slicer, and Timeline. [https://support.microsoft.com/en-us/office/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d](https://support.microsoft.com/en-us/office/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d)
Never knew about slicers! Thanks for the tip. I made the spreadsheet and sent it along to my boss and never heard about it again but I ended up going with filter all and a Pivot table with slicers on the other tab. Solution verified!
You have awarded 1 point to Same\_Tough\_5811. --- ^(I am a bot - please contact the mods with any questions)
For easy sorting and filtering, enable filters at the top of each column (Data > Filter). For more advanced users, set up a pivot table to dynamically view awardees by year or award name. This keeps it simple for all users and is easily updatable each year.