Excel Filtering/Grouping Of Project Activities

One way that I can think of is using the row grouping feature, see attached.

I have applied the grouping manually  but there are ways of doing it automatically if the real data set is much bigger.

Use the buttons in the left hand margin to collapse/expand individual groups or the number buttons at the top of the left hand margin to collapse/expand all groups to a specific level.
EE.xlsx

Hi Rob - Sorry for the delay.  Your solution seems to work, I was trying but had a hard time getting there.  Is there a particular way to sequence the grouping steps?  Thanks.  - Tom

Thanks, Rob.   The spreadsheet is not mine so I can't change it (though I can suggest changes).  The spreadsheet is not terribly large at this point, but could be someday.  I haven't done a lot of "grouping" in Excel so the process is a bit foreign to me.  My concern, and a major reason for the request, is what happens if you group 5 rows together under 1.0.  So there is 1.1, 1.2 &1.3.  But a week later there is 1.4 and 1.5.  Does the person then need to go back and group rows again?  Doesn't appear very functional when expansion is involved, which happens often.  Having said that I was hoping there might be some other Excel functionality I was not aware of

Your input has been very helpful, and I will be closing out this question as I get comfortable with working with the grouping.  I want to be sure I fulling understand how it works, and does not work, so there is no need to submit a followup question.  Thanks again Rob.  - Tom

If new rows are required within a group, when rows are inserted within or immediately below the group the new row(s) will be included in the group automatically.

Well that is nice to know.  Thank you.  - Tom

Thanks, Rob.  I appreciate your help on this.  - Tom

Happy to help