Is it possible to pass a parameter into IN operator in Query?

D

DennisS

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