Nest CHOOSECOLS inside UNIQUE to extract non-adjacent columns, and use INDIRECT for interactive header dropdowns.

Excel has native regex support, and it works exactly how you'd expect.

Stephen Myers manages a team of eight lawyers for Match Group who handle litigation for the company’s 30 brands, including Match.com, Tinder, Hinge, OkCupid and Plenty of Fish. Patrick Kleineberg/The ...