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.
T