Results 1 to 2 of 2

Thread: Filtering of 1 cell (field) and show additional cells

  1. #1

    Filtering of 1 cell (field) and show additional cells



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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,

    Process Grp Process Grp Process Grp Process Grp
    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
    2 PROC GRP
    2.1 PROC GRP
    2.1.1 PROC GRP
    2.1.1.1 PROC GRP
    2.2 PROC GRP
    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
    3 PROC GRP
    3.1 PROC GRP
    3.2 PROC GRP
    3.2.1 PROC GRP
    3.2.1.1 PROC GRP
    4 PROC GRP
    4.1 PROC GRP

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    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"


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •