Hi there. I am hoping someone can assist me.
I need to create a excel sheet for attendance.
I have attached what I have done thus far but what I want to do is count the number of times the words rescheduled, excused and did not show for each team leader.
So if someone from Jonh's team does not come I want the formula to read that John had one person that did not show.
Any idea?
I did include a validation for the drop down arrpw for the reasons now I want to link the reason to the Team leaders name.
I need to create a excel sheet for attendance.
I have attached what I have done thus far but what I want to do is count the number of times the words rescheduled, excused and did not show for each team leader.
So if someone from Jonh's team does not come I want the formula to read that John had one person that did not show.
Any idea?
I did include a validation for the drop down arrpw for the reasons now I want to link the reason to the Team leaders name.