Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pointing to the full list from a database query
Hi there, I have an excel sheet where there's a SQL query which grabs a few columns from an access database. Actually there are two or more SQL queries on the same sheet, and I search for a number X, and query 1 gives me a few columns related to X from one access database, and Query 2 gives me a few columns more on X from another database. Query 1 starts at in sheet 'Data!B2' and query 2 starts 2-3 rows below the last row in query 1. Sometimes that is just a single row from both queries, sometimes it means I get 10 rows of data each. Now, I want to work with the data from one of the columns from one of the queries, no matter how many rows the column has (it changes with value for X) What's the best way to do this? I don't like the idea of having the data on lots of different sheets.. would like to have all of the queries (there are more to come later) on the same 'data' sheet and after I've worked with the data, instance what I need to an 'overview' sheet. any good ideas? K. -- Kashgarinn ------------------------------------------------------------------------ Kashgarinn's Profile: http://www.excelforum.com/member.php...fo&userid=7951 View this thread: http://www.excelforum.com/showthread...hreadid=512298 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pointing to the full list from a database query
If I understand you correctly, a formula like:
=AVERAGE(B2:B11) will work correctly regardless of the number of filled cells in the range. Such a formula can be placed anywhere below B11 or above B2 (if you have a limited set of formulas you can consider placing them above the data). Does this help? Kostis Vezerides |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Access import query list incomplete | Excel Worksheet Functions | |||
ODBC database query | Excel Discussion (Misc queries) | |||
Excel Database Query | Setting up and Configuration of Excel | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
Dependent List Query | Excel Worksheet Functions |