Forum Discussion
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
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)
LET function is way better than mine!
Thank you for your help Ezio-de-Pazzi
can I also check I have another list of names with team member in rows
with Data and I like to display in the list tab
The team members and it's department
Can advise how to use formula to pull from the data as attached file? Thank you