So... Let's talk about Google Sheets. Years ago when I was Director of Internet Technologies for Carl Kartcher Enterprises, I had to learn Visual Basic (Viz-you-all Bzz-Kick) for Excel. It was a lot of no fun for a lot of effort, and really, after building UI for a bunch of smaller apps thre was really no point in any of it.
Come to 2019 (almost 22 years later) and now we have wonderful things like AI and Machine Learning and Google Docs and CSS! Why would anyone learn anything, when almost everythig is smart enough to fix it's own problems? Because, is why. Sometimes you need a thing to do more than look pretty—it needs to be smart. Google Sheets has UNIQUE for getting rid of duplicates, but to list duplicate items, you have to make the hoops to jump through.