Forum Discussion
BMatths
Feb 21, 2022Copper Contributor
What excel formula should I use?
Hi, I've been told to use a specific formula but I do not understand how this formula can be used with what I need to accomplish. So I've got a list of people who have or have not attended ...
OliverScheurich
Feb 21, 2022Gold Contributor
=FILTER(A2:A27,XLOOKUP(M1,B1:F1,B2:F27)=N1)With Office365 or 2021 or Excel online you can apply FILTER function to dynamically select the event and "Y" or "N" as shown in the attached file.