ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is it possible to pass a parameter into IN operator in Query? (https://www.excelbanter.com/excel-discussion-misc-queries/147948-possible-pass-parameter-into-operator-query.html)

DennisS

Is it possible to pass a parameter into IN operator in Query?
 
Hello all.
Is it possible to pass a parameter into Excel Query that uses IN operator.
Something like
IN([Param1])
where
Param1 refers to a cell in a worksheet and contains a list.

I tried to pass things like
A1=" 'first', 'second','third',..."
A1="first, second, third, ..."

nothing seems to work.
Thanks!


All times are GMT +1. The time now is 04:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com