how to match few criteria and get the result?
hi
Can anyone help on the formulas
I have two sheet, Sheet 1 Attendance and Sheet 2 Workshop attended
How to automate the attendance to match the person email to the workshop and cohort
and indicate Y attended , absent based on the data in sheet 2?
If the person attendance and sheet 2 has a grey Y it should show as Y and a badge icon – replace the current tick Yes
as I need to know if the badge has been awarded to him once it’s completed.
Can please advise? I downloaded the template fr excel temp.
Attached file.
Thank you
hi Can anyone help on the formulas I have two sheet, Sheet 1 Attendance and Sheet 2 Workshop attendedHow to automate the attendance to match the person email to the workshop and cohortand indicate Y attended , absent based on the data in sheet 2? If the person attendance and sheet 2 has a grey Y it should show as Y and a badge icon – replace the current tick Yesas I need to know if the badge has been awarded to him once it’s completed. Can please advise? I downloaded the template fr excel temp.Attached file. Thank you Read More