Google Sheets QUERY() equivalent?
I would welcome a straightforward, SQL-like function to build complex queries, similar to Google Sheets QUERY(). For me, building complex filters with multiple criteria in Excel is frustratingly difficult. This is especially true when attempting to emulate SQL's WHERE, IN, LIKE, GROUP BY, and HAVING.
For the record, I'm referring to built-in filtering (querying) of data within Excel tables, not passing SQL statements to connected SQL data server/connection.
Helman Frow commented