| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract multiple records from Excel table
I have an existing table with multiple entries. each has a status code "1" or
"2". ow do I create/extract into a new table only those records with a staus code of "1". |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract multiple records from Excel table
Use DataFilterAutomatic filter or Advanced filter
HTH -- AP "Berne van de Laar" a écrit dans le message de news: ... I have an existing table with multiple entries. each has a status code "1" or "2". ow do I create/extract into a new table only those records with a staus code of "1". |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract multiple records from Excel table
Hi
"Ardus Petus" wrote in message ... Use DataFilterAutomatic filter or Advanced filter Or an ODBC query (DataGet External Data - and you have to define the source table as a named range before) Arvi Laanemets |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
| Can I copy a table from Word into one cell in Excel without losing data? (Office 97) | Excel Discussion (Misc queries) | |||
| Linking table in Excel to word | Links and Linking in Excel | |||
| Pivot Table Security in Excel | Excel Discussion (Misc queries) | |||
| multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
Linear Mode
