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)

     

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

      • Ezio-de-Pazzi's avatar
        Ezio-de-Pazzi
        Brass Contributor
        Oct 05, 2022

        bbsin 

        please check this if I got your point. Cause like L z. said it really confused me for a long time. 

        It's pretty easy with the FILTER function. 

        =INDEX(FILTER($A$3:$C$26,$C$3:$C$26=F3),SEQUENCE(ROWS(FILTER($A$3:$C$26, $C$3:$C$26=F3))),{3,1})

        I strongly recommend you to use Excel Table to structurize data, this way it could automatically resize the data range if you add. Plus, the function would be more understandable.

        =INDEX(FILTER(List[[Table '#]:[Guest Name]],List[Guest Name]=F3),SEQUENCE(ROWS(FILTER(List[[Table '#]:[Guest Name]],List[Guest Name]=F3))),{3,1})

         

Resources