GSheet to find matching items

So you or someone you know possibly has a big set of worksheets and needs to either find things in set A but not set B, only things in both, or possibly some combination of those things.

So here is your very own “low code solution” for these inclusion/exclusion list problems. A simple gsheet that someone familiar with worksheets can use, hopefully without the help of a programmer.

No tricks, no emails signups, just a doc you can make a copy of and use on your own.

https://docs.google.com/spreadsheets/d/1NKeYQcsC9y-aZ6Eh2WYHzhJh_O55CeEwf4xicmS4Cpc/edit?usp=sharing

Use-cases could be finding unpaid invoices, finding out who is trained on a specific process, resource allocation, finding customers who were at a conference, and really anything where you need to “compare two sets of data” for matches (or non-matches).

For programmers this is quite common and probably an easy interview question they might have gotten at-least once before. For everyone who is not a programmer it usually results in manually clicking around and using a lot of time to check through these items one-by-one.

So perhaps you can’t get a programmer to do it for you, or this is “just a one off task”, or you are a programmer who is too busy to help someone else do it, or perhaps the practical implications of programming a solution for someone means you need to do some extensive setup work and ask the non-programmer to install python, node or sqlite onto their work computer and interact with a terminal and export things a special way to csv and get that IT support ticket submitted and… yeah, by the time you are done you could have manually just done it for them anyway.

So here’s a sheet that does it for you. Enjoy.