+ Reply to Thread
Results 1 to 3 of 3

Formula to select column header text based on value in a horizontal group of cells

  1. #1
    Registered User
    Join Date
    02-24-2020
    Location
    Boulder, Colorado
    MS-Off Ver
    Office 365
    Posts
    2

    Formula to select column header text based on value in a horizontal group of cells

    Hello,

    I wasn't sure exactly how to word the title of this post, so hope it wasn't too confusing.

    I have a spreadsheet outputted from a survey program. There are multiple columns that indicate all of the possible values that were available to answer a question. The selected answer is indicated with a '1' in the appropriate column. I'd like to use a function that will select the column header based on the cell that contains the '1'.

    Please see the attached sample spreadsheet which shows the original columns and the new columns that represent the desired results. I need to know what formula would yield those results.

    Thanks so much for your help!

    Ed Self
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,607

    Re: Formula to select column header text based on value in a horizontal group of cells

    Y4 (and copy down):
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    As the answers are 1-5 in consequtive columns the Z4 (and copied down) formula could be just:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    And AA4 similar:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    etc.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    02-24-2020
    Location
    Boulder, Colorado
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Formula to select column header text based on value in a horizontal group of cells

    Thank you so much for the quick response. Worked perfectly!

+ 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. Need a Formula to copy data to different cells based on a column header
    By jpiquette in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2019, 12:22 PM
  2. Select column based on header VBA
    By chilli16 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2018, 08:06 AM
  3. [SOLVED] Select column based on column header name
    By D_N_L in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2014, 08:09 AM
  4. Replies: 1
    Last Post: 02-10-2014, 10:26 PM
  5. Group value in columns with header based on value in another column
    By hitarov in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-02-2013, 03:44 AM
  6. Range Select Based on Column Header
    By Nospmas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2013, 11:27 AM
  7. Replies: 2
    Last Post: 08-09-2012, 09:16 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