I need help figuring out a formula for the below (see image). I am trying to determine if every employee has a rating for each of their goals. For example, I need a formula that would look down column A and determine that Employee A who has 3 goals (Column B) has a rating for each. 

​I need help figuring out a formula for the below (see image). I am trying to determine if every employee has a rating for each of their goals. For example, I need a formula that would look down column A and determine that Employee A who has 3 goals (Column B) has a rating for each.     Read More

​