+ Reply to Thread
Results 1 to 8 of 8

Return column name

  1. 03-17-2021, 07:45 AM #1
    Hubusss
    Hubusss is offline
    Registered User
    Join Date
    03-17-2021
    Location
    Poole, England
    MS-Off Ver
    Excel for Microsoft 365 (16)
    Posts
    6

    Return column name

    Hi all, I am trying to find a way of returning the column names for the row if the row shows a value. As per example row 8 (ACBE-BLE-024V-MI01) I would like to see the result "DESK, FDesk". Can you help please? See picture for expected results.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Hubusss; 03-17-2021 at 01:00 PM.
    Reply With QuoteRegister To Reply
  2. 03-17-2021, 09:05 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Return column name

    Please add some expected results to your sheet. Thanks
    Reply With QuoteRegister To Reply
  3. 03-17-2021, 09:09 AM #3
    omahaNative_1023
    omahaNative_1023 is offline
    Banned User!
    Join Date
    01-17-2021
    Location
    Omaha, NE
    MS-Off Ver
    office 2016
    Posts
    211

    Re: Return column name

    you have point to target cell where those values are. those names are not column headings and names. they values inside cells. columns indexed and have numbers like they say

    https://docs.microsoft.com/en-us/off...l.range.column

    otherwise, you need functions or code like offset.
    Reply With QuoteRegister To Reply
  4. 03-17-2021, 12:58 PM #4
    Hubusss
    Hubusss is offline
    Registered User
    Join Date
    03-17-2021
    Location
    Poole, England
    MS-Off Ver
    Excel for Microsoft 365 (16)
    Posts
    6

    Re: Return column name

    Expected results would look like this (cell address: EZ8)
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  5. 03-18-2021, 04:54 AM #5
    Hubusss
    Hubusss is offline
    Registered User
    Join Date
    03-17-2021
    Location
    Poole, England
    MS-Off Ver
    Excel for Microsoft 365 (16)
    Posts
    6

    Re: Return column name

    omahaNative_1023

    Would you be able to post a formula on above example to explain what you mean?
    Reply With QuoteRegister To Reply
  6. 03-18-2021, 05:06 AM #6
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Return column name

    Is this what you mean?? In EZ5, copied down:

    =TEXTJOIN(", ",TRUE,IF(B5:EX5<>"",$B$4:$EX$4,""))

    NB. Next time, please re-read the yellow banner (top) about the size of sample sheets.... 155 columns is just a little bit excessive!!
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  7. 03-18-2021, 07:13 AM #7
    Hubusss
    Hubusss is offline
    Registered User
    Join Date
    03-17-2021
    Location
    Poole, England
    MS-Off Ver
    Excel for Microsoft 365 (16)
    Posts
    6

    Re: Return column name

    Awesome, thanks for help, this is exactly what I was after!

    Sorry about the file size, will remember this for the next time.
    Reply With QuoteRegister To Reply
  8. 03-18-2021, 07:39 AM #8
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Return column name

    You're welcome.


    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to return value in column adjacent to item in Sheet2 and return results in Sheet1?
    By aswethink in forum Excel General
    Replies: 6
    Last Post: 02-22-2021, 05:27 PM
  2. Formula to look through a Table and return zero and 1 or zero and zero in column K
    By bjnockle in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-09-2020, 06:25 PM
  3. How do I program Excel to return to column A after pressing return/enter?
    By IT_Padawan in forum Excel General
    Replies: 3
    Last Post: 11-02-2018, 11:59 AM
  4. Compare multiple columns (column A,column B,Column C) and return value (Column D)
    By john008 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2015, 08:24 AM
  5. [SOLVED] How to return address of the column or cell I select, not just return the value?
    By qzqzjcjp in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-18-2014, 04:57 PM
  6. Using Lookup to Return Column Header or Index Function to return revised pay rate
    By lovesexcel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-13-2013, 12:38 PM
  7. [SOLVED] Index Row and return data in a Single Column:No return
    By Domenic in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 04: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1