I am the head lifeguard at my local beach and am looking to make the way I place my guards more efficient. I have a sheet full of my guards and where they have been located each day. What I need is a way to use a new sheet to type in the guards name and have it pull data from the original sheet to show me where they have been located most often and least often. Attached is an incomplete version of the spreadsheet. Any help would be great!!
Lifeguards.xlsx
Bookmarks