+ Reply to Thread
Results 1 to 7 of 7

Listing column headings based on cell values

  1. #1
    Registered User
    Join Date
    06-07-2023
    Location
    Sydney, Australia
    MS-Off Ver
    Office 365
    Posts
    23

    Listing column headings based on cell values

    Hi,
    I have a table (example attached) with row and column heading values. Some of the cells in the table have a value ("y").
    When I select a value of Column A (Permissions in example) I would like all of the headings to list underneath each other that contain the value of "y".

    Hopefully the example sheet makes it clearer what I'm after.

    Thanks

    UPDATE: nevermind, I worked it myself, thanks anyway!!
    Attached Files Attached Files
    Last edited by Mosom; 01-28-2024 at 08:10 PM.

  2. #2
    Registered User
    Join Date
    06-07-2023
    Location
    Sydney, Australia
    MS-Off Ver
    Office 365
    Posts
    23

    Re: Listing column headings based on cell values

    Sorry, I didn't provide my solution.
    See attached example sheet for solution. I needed to tranpose my table first - maybe someone else has a way of doing it without tranposing?
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,783

    Re: Listing column headings based on cell values

    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    1
    Role 1 Role 2 Role 3 Role 4 Role 5 Drop down list of Permissions: Permission 1
    2
    Permission 1 y y y
    3
    Permission 2 y y
    4
    Permission 3 y y y What I want to appear: Role 1
    5
    Permission 4 y y Role 3
    6
    Permission 5 y y y y Role 5



    j4=TOCOL(FILTER(B1:F1,INDEX(B2:F100,MATCH(J1,A2:A100,0),)="y"))

  4. #4
    Registered User
    Join Date
    06-07-2023
    Location
    Sydney, Australia
    MS-Off Ver
    Office 365
    Posts
    23

    Re: Listing column headings based on cell values

    Thanks heaps, that's a lot easier than transposing the data to a new table. Much appreciated

  5. #5
    Registered User
    Join Date
    06-07-2023
    Location
    Sydney, Australia
    MS-Off Ver
    Office 365
    Posts
    23

    Re: Listing column headings based on cell values

    Follow up question for anyone able to help...

    I Need a new filter of Office titles that hold teh relevant roles based on the permissions.
    The attached sheet shows what I need in the blue areas.

    Thanks heaps in advance.
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,783

    Re: Listing column headings based on cell values

    N17=unique(filter(choosecols(hstack(tocol(ifna(n2:n7,o2:s7)),tocol(ifna(o2:s7,n2:n7))),1),isnumber(match(choosecols(hstack(tocol(ifna(n2:n7,o2:s7)),tocol(ifna(o2:s7,n2:n7))),2),l17:l18,0))))
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    06-07-2023
    Location
    Sydney, Australia
    MS-Off Ver
    Office 365
    Posts
    23

    Re: Listing column headings based on cell values

    Thanks for that, much appreciated!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Consecutive repeat of column headings based on cell values
    By mikear82 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-24-2018, 08:49 AM
  2. Show column headings and corresponding values/text based on dropdown selection
    By deedee90 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-03-2018, 07:03 AM
  3. [SOLVED] Listing unique values, based on matching two other columns in a single cell
    By bsamson05 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-17-2016, 03:36 PM
  4. Summing values based on criteria located in column and row headings
    By talbarnett in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-02-2015, 02:18 AM
  5. Need to convert cell values to column headings
    By faizaan316 in forum Excel General
    Replies: 1
    Last Post: 05-02-2013, 01:03 PM
  6. Listing values into one cell based on a status...
    By wanton007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2009, 02:52 AM
  7. [SOLVED] listing values to choose from based on value in another cell
    By MT in forum Excel General
    Replies: 1
    Last Post: 09-12-2005, 09:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1