trained

I have a quandry. I am trying to create a drop down list or similar to show me All employees and the single task they "HAVE NOT" been trained on yet. I have 52 employees and 20 tasks they need to be trained on. I know I can create a table and add a filter to show ALL employees that have not yet...

Hey folks a lot smarter than I am, I would appreciate some help. I have a large table of employee trained tasks: about 100 employees as rows and 50ish tasks as colums that each employee can be trained in. I would like to set up two different lists: one by task (so everyone trained in task A) and...

Hi all, I hope this is possible, what I am building is a skills matrix, which will have an X in a cell, if someone is trained in a set task. What I would like to know is that, when someone logs on, by supplying their employee id, zbc123, it looks in the list for their name and then see's what...

Hi, I am looking for some help with a formula. I am creating a training matrix. the training values are 1,2,3,4 (1=training, 2=trained with minimal supervision, 4 = fully trained etc) My current formula is.. =COUNTIF(AR7:BB7,">1")*4 AR7:BB7 is my range I'm looking at, ">1" is saying count...

<tbody> TODAY DATE TRAINED DATE CERTIFY BY DATE CERTIFIED DAYS DELINQUENT </tbody> I'm looking for assistance with a formula that will calculate days delinquent. DATE TRAINED can be blank if not trained. DATE CERTIFY BY is one year (365 days) after date entered in DATE TRAINED...