I needed to build a query within an Excel spreadsheet. This query takes
parameters form cells in other spreadsheet.
The problem I faced is that I don't know what value needs to be put into the
cell in order to select all values for given parameter in the examlpe below
this would be "Country" and "Product". I tried many things but none of them
works e.g. "*"

..........WHERE (`Sheet1$`.Country=?) AND (`Sheet1$`.Product=?)

Thanks a milion for someone who know a simple solution.
Cheers

Check out the Sumproduct() function.
This will do the trick.

"facet" wrote in message
...
I needed to build a query within an Excel spreadsheet. This query takes
parameters form cells in other spreadsheet.
The problem I faced is that I don't know what value needs to be put into
the
cell in order to select all values for given parameter in the examlpe
below
this would be "Country" and "Product". I tried many things but none of
them
works e.g. "*"

.........WHERE (`Sheet1$`.Country=?) AND (`Sheet1$`.Product=?)

Thanks a milion for someone who know a simple solution.
Cheers

How have you built the query? Can we see the code?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"facet" wrote in message
...
I needed to build a query within an Excel spreadsheet. This query takes
parameters form cells in other spreadsheet.
The problem I faced is that I don't know what value needs to be put into
the
cell in order to select all values for given parameter in the examlpe
below
this would be "Country" and "Product". I tried many things but none of
them
works e.g. "*"

.........WHERE (`Sheet1$`.Country=?) AND (`Sheet1$`.Product=?)

Thanks a milion for someone who know a simple solution.
Cheers

How exactly should I use this function ? Could you get me some example ?
Cheers

U¿ytkownik "Jim May" napisa³ w wiadomo¶ci
news:e%H8f.28499$OM4.28222@dukeread06...
Check out the Sumproduct() function.
This will do the trick.

"facet" wrote in message
...
I needed to build a query within an Excel spreadsheet. This query takes
parameters form cells in other spreadsheet.
The problem I faced is that I don't know what value needs to be put into
the
cell in order to select all values for given parameter in the examlpe
below
this would be "Country" and "Product". I tried many things but none of
them
works e.g. "*"

.........WHERE (`Sheet1$`.Country=?) AND (`Sheet1$`.Product=?)

Thanks a milion for someone who know a simple solution.
Cheers

Go to:

http://www.dicks-blog.com/archives/2...with-wildcard/

for a good review..


"facet" wrote in message
...
How exactly should I use this function ? Could you get me some example ?
Cheers

U¿ytkownik "Jim May" napisa³ w wiadomo¶ci
news:e%H8f.28499$OM4.28222@dukeread06...
Check out the Sumproduct() function.
This will do the trick.

"facet" wrote in message
...
I needed to build a query within an Excel spreadsheet. This query takes
parameters form cells in other spreadsheet.
The problem I faced is that I don't know what value needs to be put
into
the
cell in order to select all values for given parameter in the examlpe
below
this would be "Country" and "Product". I tried many things but none of
them
works e.g. "*"

.........WHERE (`Sheet1$`.Country=?) AND (`Sheet1$`.Product=?)

Thanks a milion for someone who know a simple solution.
Cheers