Forum Discussion
Tracking attendance at training using Polls on MS Teams and Excel
I am trying to establish what players are A. at training, B. not there and C. are there but not participating. I want to organise and track this data using Excel. If I post a Poll on MS Teams, I can...
Worth try this:
- Create a Master List:
- List all 45 players in one column.
- Use VLOOKUP to Match Responses:
- Assuming your master list is in column A and the poll responses are in columns B, C, and D:=IFERROR(VLOOKUP(A2, $B$2:$D$11, 3, FALSE), "No Contact")
- This formula checks if a player’s name from the master list appears in the poll responses and returns the corresponding response. If not found, it returns “No Contact”.
3. Track Attendance Over Multiple Sessions
To track attendance over multiple sessions, you can set up a table with player names and columns for each session:
- Create a Table:
- Column A: Player Names
- Columns B to AE (or more): Each training session
- Fill in Attendance:
- For each session, fill in the attendance status (e.g., “Yes”, “No”, “Yes but injured”, “No Contact”).
- Use Conditional Formatting:
- Highlight cells based on their values to easily visualize attendance patterns.