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.

--
Regards
Roger Govier

"Chddb" wrote in message
...
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.