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)
