I have a Google Sheet that has ~5000 rows of items that I need to sort/filter by various means and I can't seem to wrap my brain around it. I've sorted them alphabetically but I feel like what I need is simple and can be accomplished by a script or a bunch of vlookup functions tied with Sort/Filter commands.
I have eight columns worth of data that need to be sorted/filtered.
- Column A - Name of Person
- Column B - Site
- Column C - Item
- Column D - Tag # of Item
- Column E - Serial # of Item
- Column F - Date Item was Checked Out
- Column G - Date Item was Checked In
- Column H - Notes (if any)
So if I have Jon Doe who's checked out 60 different items over 12 years, I need a way to sort/filter which items have already been checked in, and which items are still outstanding and what those items are so we can contact Jon Doe and let them know he still has 15 items outstanding, what those items are, they're SN #'s, and any notes as well as provide the date he checked out those items. Without having to manually go through and delete the items from this massive list that he's already checked back in. As well as doing this for each person on this list.
Can someone help me with this?