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

Table list test.xlsx12 KB

excel

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)
Table list test (awards).xlsx20 KB

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

Table list test.xlsx19 KB

bbsin
Iron Contributor
Oct 04, 2022
hi Lorenzo

Great . Thank you
- bbsin
  Iron Contributor
  Oct 04, 2022
  Hi Lorenzo
  
  my end cannot work . it show SPILL
  
  do advise thx
  - 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

Forum Discussion

excel how to display table with list of members

Resources