Forum Discussion

bbsin's avatar
bbsin
Iron Contributor
Oct 04, 2022
Solved

excel how to display table with list of members

hi I have a list of names, with it's table number   may I know how to display them into the table number with the list of people in?   Thank you   As attached excel
excel
  • Ezio-de-Pazzi's avatar
    Ezio-de-Pazzi
    Oct 06, 2022

    bbsin 

    There is no need to manually set every filter function. Since there are relative references to table number, you could easily complete every table sheet by just copy and paste it.

    And you don't have to reference one column in every filter function. Below should be better.

    =FILTER(List[[Guest Name]:[Catoegry]],List[Table '#]=I9)

     

Lorenzo's avatar
Lorenzo
Silver Contributor
Oct 04, 2022

bbsin 

 

See https://support.microsoft.com/en-us/office/how-to-correct-a-spill-error-ffe0f555-b479-4a17-a6e2-ef9cc9ad4023

bbsin's avatar
bbsin
Iron Contributor
Oct 04, 2022
Thank you. Will try it out.

Cheers,
  • bbsin's avatar
    bbsin
    Iron Contributor
    Oct 05, 2022
    hi

    I have a question, may I know how display name that are "Award" from a range table range

    to show which table and name that are = Awards in a table to display
    the names and it's table number

    thanks
    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Oct 05, 2022
      Not sure I understand. Could you supply a sample with dummy data + the expected result? Thanks
      • bbsin's avatar
        bbsin
        Iron Contributor
        Oct 05, 2022

        Hi 

        Lorenzo 

         

        Example I like to show the Award 1 and Award 2
        in the table with guest name and it's table no that match to Award 1 and so for.

        as attached

         

        Thank you

Resources