SQL query in Excel - help !
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 |
SQL query in Excel - help !
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 |
SQL query in Excel - help !
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 |
SQL query in Excel - help !
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 |
SQL query in Excel - help !
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 |
All times are GMT +1. The time now is 10:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com