Attendance Sheet Help

%3CLINGO-SUB%20id%3D%22lingo-sub-2309792%22%20slang%3D%22en-US%22%3EAttendance%20Sheet%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2309792%22%20slang%3D%22en-US%22%3EHey%20all%2C%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20is%20my%20first%20post%2C%20so%20I%20am%20sorry%20if%20it%20is%20a%20silly%20one%2C%20but%20I'm%20looking%20for%20some%20help.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20built%20a%20training%20programme%20primarily%20using%20Microsoft%20Forms%20(or%2C%20alternatively%2C%20if%20training%20is%20delivered%20in%20person%20then%20the%20participants%20will%20complete%20a%20Form%20for%20feedback)%20and%20I%20have%20got%20this%20to%20sync%20with%20Excel%3B%20dropping%20their%20credentials%20and%20answers%20into%20the%20spreadsheet.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%2C%20on%20sheet%201%2C%20I%20have%20a%20list%20of%20names%20and%20user%20ID's%20who%20should%20have%20completed%2Fattended%20the%20training%20session%20and%20on%20sheet%202%20I%20have%20all%20this%20data%20being%20fed%20into%20excel%20by%20the%20people%20who%20*actually*%20attended%20(thus%2C%20completing%20my%20%22Form%22)%20-%20is%20there%20any%20function%20that%20could%20either%20highlight%20or%20simply%20put%20a%20Y%20or%20N%20into%20a%20column%20for%20%22Attended%3F%22%3F%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20suggestions%20would%20be%20most%20appreciated!%3CBR%20%2F%3E%3CBR%20%2F%3EHave%20a%20good%20day%2C%20y'all%20and%20take%20care.%3CBR%20%2F%3E%3CBR%20%2F%3ET%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2309792%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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.

T
0 Replies