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

HIi bbsin 

 

With Excel 2021 or 365 you case use the https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759 function - see attachment

bbsin's avatar
bbsin
Iron Contributor
Oct 04, 2022
hi Lorenzo

Great . Thank you
  • bbsin's avatar
    bbsin
    Iron Contributor
    Oct 04, 2022

    Hi Lorenzo 

     

    my end cannot work . it show SPILL

     

    do advise thx

     

    • 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,
    • Ezio-de-Pazzi's avatar
      Ezio-de-Pazzi
      Brass Contributor
      Oct 04, 2022
      List of people by table 
      Table 1
      #SPILL!　
      　　
      　　
      redundancy data　

      You need to make sure there is no other data occupied in the array space. 

      bbsin 

Resources