| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL.REQUEST Returns Single Cell
I enter a sql.request function in a worksheet cell, and it returns only the
first column of the first matching row of the database. How can I modify the syntax to return all columns in all matching rows? Thanks for the assistance. Glenn |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SQL.REQUEST Returns Single Cell
You need to enter this as an array formula. Use ctrl + shift + enter
"Glenn1203" wrote: I enter a sql.request function in a worksheet cell, and it returns only the first column of the first matching row of the database. How can I modify the syntax to return all columns in all matching rows? Thanks for the assistance. Glenn |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SQL.REQUEST Returns Single Cell
Thanks James. So the sequence would be to enter the formula in a cell, but
instead of hitting enter, I should hit ctrl+shift+enter? I tried that, and it didn't change the result. What could I be doing wrong? Thanks, Glenn "James W." wrote: You need to enter this as an array formula. Use ctrl + shift + enter "Glenn1203" wrote: I enter a sql.request function in a worksheet cell, and it returns only the first column of the first matching row of the database. How can I modify the syntax to return all columns in all matching rows? Thanks for the assistance. Glenn |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SQL.REQUEST Returns Single Cell
You have to select as many cells (rows and columns) as you expect it to
return data if you are going to try ctrl+Shift+enter. You select the cells, go to the formula bar and enter the formula, commit with Ctrl+Shift+Enter -- Regards, Tom Ogilvy "Glenn1203" wrote in message ... Thanks James. So the sequence would be to enter the formula in a cell, but instead of hitting enter, I should hit ctrl+shift+enter? I tried that, and it didn't change the result. What could I be doing wrong? Thanks, Glenn "James W." wrote: You need to enter this as an array formula. Use ctrl + shift + enter "Glenn1203" wrote: I enter a sql.request function in a worksheet cell, and it returns only the first column of the first matching row of the database. How can I modify the syntax to return all columns in all matching rows? Thanks for the assistance. Glenn |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SQL.REQUEST Returns Single Cell
That was the ticket! Thanks for the help. Glenn
"Tom Ogilvy" wrote: You have to select as many cells (rows and columns) as you expect it to return data if you are going to try ctrl+Shift+enter. You select the cells, go to the formula bar and enter the formula, commit with Ctrl+Shift+Enter -- Regards, Tom Ogilvy "Glenn1203" wrote in message ... Thanks James. So the sequence would be to enter the formula in a cell, but instead of hitting enter, I should hit ctrl+shift+enter? I tried that, and it didn't change the result. What could I be doing wrong? Thanks, Glenn "James W." wrote: You need to enter this as an array formula. Use ctrl + shift + enter "Glenn1203" wrote: I enter a sql.request function in a worksheet cell, and it returns only the first column of the first matching row of the database. How can I modify the syntax to return all columns in all matching rows? Thanks for the assistance. Glenn |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| From single cell variables to a single column serie | New Users to Excel | |||
| cell with value returns that value, empty cell returns zero | Excel Worksheet Functions | |||
| function that returns a list to a single cell | Excel Discussion (Misc queries) | |||
| VBA for the case when web request returns nothing. | Excel Programming | |||
| Range.Find returns cell outside of range when range set to single cell | Excel Programming | |||
Linear Mode
