Attendance Sheet Help

Occasional Visitor
Hey all,

This is my first post, so I am sorry if it is a silly one, but I'm looking for some help.

I have built a training programme primarily using Microsoft Forms (or, alternatively, if training is delivered in person then the participants will complete a Form for feedback) and I have got this to sync with Excel; dropping their credentials and answers into the spreadsheet.

If, on sheet 1, I have a list of names and user ID's who should have completed/attended the training session and on sheet 2 I have all this data being fed into excel by the people who *actually* attended (thus, completing my "Form") - is there any function that could either highlight or simply put a Y or N into a column for "Attended?"?

Any suggestions would be most appreciated!

Have a good day, y'all and take care.

0 Replies