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!
|