Excel 2013 - Filtering/DrilDown Data

[dducky]

Hi, I have an Excel question (Example attached in file). I am trying to create a list of data (that will grow) and I need to be able to filter down.

1st-Question- I have 6 rows (Area, Subject, Date, Open/Close, SR Open/Close, SR Data) I have Area, Subject, Date Open/Close (Merged & Centered) with multiple lines. The reason, because there can be MANY SR's under SR Open/Close & SR Data. The problem is, when I do a filter search on Area or Subject or Date or Open/Close, it only will display the first SR Data. How do I make Excel, when I do a filter search on (Area/Subject/Date/Open/Close) ALL the SR's (on multiple rows) are displayed for whatever Area, Subject, Date I choose?

2nd Question: Do you know of a better way/process that is better to view this data and easier for my readers to view and utilize this report? I want them to be able to see everything or drilldown to specific "Subjects" and see the associated SRs (all of them). So, for example, under Area I can have (Questions, Data, Concerns), then under Subject (under the " Area" of Questions I can have several "Subjects" such as Airfare, Rental Car, etc.), under "Date" (under the "Area" of Questions, under "Subjects" of Airfare, I select the Date). I want to be able to either display ALL data or be able to filter on any of these columns (Area, Subject, Date, etc.) and drill down to specific subject, but, (from my first question) if I pick on any Subject, I want to be able to see all the associated SR's from the SR column. Under the Subject, there can be multiple SR, so when i filter I want to see all those SRs in the different Rows. So, for example, when I filter down Area and then Subject, I should see the 10 SR's (on 10 different rows) for that Subject I just drilled/filtered down too?

I hope this is not confusing.... THank you so MUCH in advance!
Shawn

[tuph]

This happening because of the merged cells. The date only resides in the topleft cell of the merged range. So the range C2:C4 actually only contains 1 date entry - in cell C2.

If you unmerge the cells then enter the date into each one your filters will work better.

This also applies to columns A and B.

[dducky]

HI, thanks for the info. That is exactly what I am trying to do. I will have to have the merged cells, because these cells need to be listed as 1, however, the SR columns can have over 10 SR, so I want them in different cells. Is there a way when you sort on any of the merged cells all the SR cell/rows will be displayed under those merged cells (something like can their we association of those rows with the merged row)? I dont know....thanks!!!!