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)
Hi bbsin
Your sample was confusing as some Gest Names had "Awardx". Highlighted in orange in the attached file is what I modified with the hope this reflects your actuals
in F5:
=LET(
flt, FILTER(A3:C26, D3:D26=F3),
INDEX(flt, SEQUENCE(ROWS(flt)), {3,1})
)
(If it was me I would format your List as a Table - see some benefits here )
- thank you. this works.
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
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
