i work in a bowling alley where we keep track of the calls we have come to the back. right now I just have a spreadsheet that tells me what lanes on what day I had a call (lane 1 had 1 sweep call). then I add them up to get the total calls for the day and eventually the month to see where my problem lanes are. right now all I can see is the number of calls but I want to be more specific and have a list of why the call happened but I don't want it cluttered with a bunch of words and still be able to add those numbers up. I would like to be able to hover or click on the cell and get the list of what happened for that call (there are many ways to have a sweep call). is this possible? I'm using excel 2010. I will leave a pic of the spreadsheet I have for reference.
p.s. i figured out how to use data validation and click and add more than 1 thing to a cell from the list.
Screenshot 2020-12-18 153726.png
Bookmarks