Filtering of 1 cell (field) and show additional cells

Hello,
I would like help to be able to 'filter' against a specific name, but also show cells that are part of that filtered Sub-Process group (like shown in the attached example)


In the below example - I would like to be able to filter against '1 PROC GRP', but also see all the cells that are part of '1 PROC GRP' (i.e 1 PROC GRP should show the following results only)
1 PROC GRP
1.1 PROC GRP
1.2 PROC GRP
1.2.1 PROC GRP
1.2.1.1 PROC GRP
1.2.1.2 PROC GRP
1.3 PROC GRP
1.3.1 PROC GRP

I would also like to be able to filter against any Sub-Process Grp and see all the cells that are part of that grp. For example - '2.3 PROC GRP' should show the following
2.3 PROC GRP
2.3.1 PROC GRP
2.3.1.1 PROC GRP
2.3.1.2 PROC GRP
2.3.1.3 PROC GRP

the filter of '3.2.1 PROC GRP' should show the following
3.2.1 PROC GRP
3.2.1.1 PROC GRP

Any help with resolving this issue would be very much appreciated.

Thanks,

Format a separate "input" cell as TEXT. Then enter the filter you want, e.g. 2.3

Now, assuming your table is in A to D, and your input cell above is in, say, J1, add another column to the table, with header Helper, with formula in E2:

=IF(COUNTIF(A2: D2,$J$1&"*"),"x","")

Note: You will need to unfilter and re-filter each time you change the input....

copied down.

Now filter the table on this new column for "x"