Hi,

As far as I know you cannot. Try using Advanced Filtering, database
functions, or functions like Sumproduct to get the results you wish.

John

"S K Srivastava" wrote:

I am trying to use MS query to query a list in MS Excel. So far I am not able
to do it. I want to know whether it is at all possible to query a table (or
list) in an excel sheet by using MS Query in same excel sheet or not?