+ Reply to Thread
Results 1 to 3 of 3

return row and column headers

  1. #1
    Registered User
    Join Date
    11-11-2015
    Location
    Australia
    MS-Off Ver
    MS Pro 2010
    Posts
    2

    return row and column headers

    Hi I have table
    as
    A B C D F
    V 1 1 0 0 1
    W 2 0 2 2 2
    X 1 0 2 0 0
    Y 1 1 1 1 2
    Z 1 1 1 2 1
    Where ABCD are columns B,C,D,E,F and VWXYZ rows

    I want to autimatically to return the row headers for respective occurence of 1's ,2's and 0's when i choose
    so it will look like
    Eg; for 2's
    A W
    B
    C W X
    D W Z
    E W Y

    and vice versa

    V
    W A C D E
    X C
    Y E
    Z D

    Thanks can anyone help me?
    I have tried using if function but that only returns values only where is is equal to whatever present in first table

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,641

    Re: return row and column headers

    May be this attachment helps.
    Attached Files Attached Files
    Quang PT

  3. #3
    Registered User
    Join Date
    11-11-2015
    Location
    Australia
    MS-Off Ver
    MS Pro 2010
    Posts
    2

    Re: return row and column headers

    Thank you so much .! It really works

+ 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] Return list of column headers based on cell value
    By akshaysudhir in forum Excel General
    Replies: 4
    Last Post: 04-17-2015, 06:10 AM
  2. How to return column headers for where certain values appear in each row
    By gc-spurs in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-16-2014, 07:05 PM
  3. Search for value in multiple columns, Return Column Headers
    By Zach51215 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-30-2013, 06:49 AM
  4. [SOLVED] VBA: Loop through cells in matrix and return column- and row headers
    By Søren Larsen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2012, 08:43 AM
  5. Replies: 2
    Last Post: 05-09-2012, 01:30 PM
  6. Replies: 11
    Last Post: 02-08-2012, 01:25 PM
  7. return a value based on column and row headers
    By jimmy1981 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-01-2012, 11:02 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