Relative Content

Tag Archive for sqlsql-serverexcelpowerquery

Excel SQL query slow with IN operator

I am looking for a more efficient method of designing this query.
It is referencing 80 named cells in Excel and using an IN operator to compare the named cells.
I think the problem is with the IN operator, but I don’t know of anyother way to reference the named cells in Excel.