Forum Discussion
excel how to display table with list of members
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)
I user the fitler and the table display automatically
is there any way not to show the SPILL and
the arrangement was auto pick, they empty cells are showing follow by names in the guest column, how can i not sure the empty cell in the display table with the formula? Thank yoyu
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)
- thank you. this works.