Lists in Excel 2003

  • Thread starter Thread starter Chddb
  • Start date Start date
C

Chddb

I am attempting to include a list function in a large spreadsheet. However
some of the rows are subcategories of the cells above them. Is there a way
for me to have Excel view the main cell and sub cells as just one in the
list? Any help would be appreciated as I have been working on this
spreadsheet for two weeks and am finally done...minus the list function.
 
hi

Not unless you create an extra column.
the first column would contain the main Category, with an entry in each row.
the second category column would contain the sub category.
Filter on the first column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table filter list - listing irrelevant subcategorys 1
Anyone Else Facing Public Folder Migration Errors in Exchange? 0
Date filters in List for Excel 2003? 1
Using Excel Functions (Array) to put a list in alphabetical order 3
Excel 2003: Keeps applying auto-font settings I don't want 1
How do I insert a photo into a specific cell? 3
picture is too large and will be truncated - Excel 2007 3
Displaying arrow in a dropdown list within cell 2

Back
Top