Results 1 to 2 of 2

Thread: How to create lists from intersecting column and row headers?

  1. #1

    How to create lists from intersecting column and row headers?



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

    Hi I currently have a table with column and row headers. Row headers are pupils names. Column headers are activities. If a pupil is going on a certain activity I put the letter Y in the cell. What I would like to do is create a new table which looks at a pupils name, searches along their row and when it finds a Y it will just simply give the name of the activity.

    Such as

    John cinema bowling paintballing
    Connor paintball ice skating

    Etc

    Sorry I am posting this from my phone.

    Any help would be great

    Thanks

    Marcus

  2. #2
    Acolyte Azumi's Avatar
    Join Date
    Jan 2014
    Location
    Indonesia
    Posts
    29
    Articles
    0
    Excel Version
    2010
    You have your sample workbook? maybe we can figure it out faster with it... try to upload it at the forum

    Azumi

Posting Permissions

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