Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create new excel table with filtered records from another table
I have a table with multiple records and many columns. Each record has a
status field with values either 1 or 2 (open or closed). I wish to create a new shorter table in the same worksheet with only the "open" records. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create new excel table with filtered records from another table
Berne
Highlight your headers and go to datafilterautofilter... and filter your open and close column how you'd like -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Berne van de Laar" <Berne van de wrote in message ... I have a table with multiple records and many columns. Each record has a status field with values either 1 or 2 (open or closed). I wish to create a new shorter table in the same worksheet with only the "open" records. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create new excel table with filtered records from another table
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2k Pivot Table refresh scenario | Excel Discussion (Misc queries) | |||
Update Excel table in Word automatically from data in Excel | Excel Discussion (Misc queries) | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
import web table to excel | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) |