|The closest I could find was the method shown in the video I've linked to below. This method requires 2 criteria to create a list.|
You have 2 options:
1 - Use a "helper column" with a second criteria that will always be true. You could even hide this column so it won't be "distracting".
2 - Keep searching through this gentleman's Excel Magic Tricks until you find one that only uses 1 criteria.
As you'll see from the video, keep in mind that trying to use formulas in places where Filters were designed to be used is pretty complicated. Even the author mentions that in some of his videos.
If you set up an Advanced Filters correctly, you can enter your criteria in a single cell and the filter will update automatically.
However, if you really want a formula method, watch this video:
Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.