Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter entire columns
Hi,
I've downloaded a large database. Columns are labled like this: 3/31/06 AAA | 3/31/06 BBB| 3/31/06 CCC | 6/30/06 AAA | 6/30/06 BBB | 6/30/06 CCC I just want to view all columns that contain the label "AAA" So I have: 3/31/06 AAA | 6/30/06 AAA Of course I have years of quarterly data... is there an easy way to do this? Pivot table seems to take too long to manually set up... Looking for something similar to an autofilter solution Thanks very much. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenating entire columns | Excel Discussion (Misc queries) | |||
In Excel how can I filter multiple columns SIMULTANEOUSLY? | Excel Discussion (Misc queries) | |||
I need a specific value in auto filter to fill a combo box and than match the select value in 2 other columns. | Excel Worksheet Functions | |||
Delete rows based on multiple criterias | Excel Discussion (Misc queries) | |||
Convert entire columns of text email addresses to hyperlinks | Excel Worksheet Functions |