Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Querying a range within Excel
Hi,
Wondering if anyone can advise how to query a named range within an excel spreadsheet. ie rather than query an external datasource I would like to have a table in excel that is named by a range and then query the range using criteria to return a sub set of records. I would prefer not to do this using pivot tables, unless there is a way to turn off the GUI interface to pivot tables. Thanks -- David Wright |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel finds a value that is not in the lookup range | Excel Worksheet Functions | |||
allow users to edit a range in excel 2000 | Excel Discussion (Misc queries) | |||
Passing Excel NAMED Range to VBA | Excel Worksheet Functions | |||
Excel Range Names | Excel Discussion (Misc queries) | |||
Excel List range, filter arrows disappeared | Excel Discussion (Misc queries) |