Forum Discussion
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 ...
Assuming you have the latest Excel FILTER() would be even easier:
=FILTER([LIST OF NAMES], [Col with Y/N]='Y',"")
=FILTER([LIST OF NAMES], [Col with Y/N]='Y',"")
mtarler OliverScheurich Hi, I can't use a filter as the registers need to be on a separate excel spreadsheet. There are a lot of events and only certain people need to see the data for each club to safeguard data so I need a separate spreadsheet that automatically updates.
=FILTER(A2:A27,SWITCH(M1,"Event 1",Tabelle31!B2:B27,"Event 2",C2:C27,"Event 3",Tabelle28!U2:U27,"Event 4",Tabelle27!O2:O27,"Event 5",Tabelle26!L2:L27)=N1)This works in my spreadsheet. 4 of 5 events are located on different sheets ("Tabelle31", "Tabelle28", "Tabelle27" and "Tabelle26") in this example.
- I believe BMatths is saying they are in a completely different workbook. The problem then is that worksheet functions will only update from an external workbook when that other workbook is open. You could use power query to get the data and that query can update on open but it still won't be 'live' since you will have to refresh data to get another update.
