Forum Discussion
Formula Excel Help
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 colum...
Since you have it so neatly organized this is the perfect use case for a pivot table!
Pivot out the count or the sum
I would also use the pivot table as your data will inevitably lead to someone forgetting to enter one of the rows, so you'll have two entries for one and perhaps four for another. The pivot table would immediately show that.
Pivot out the count or the sum
I would also use the pivot table as your data will inevitably lead to someone forgetting to enter one of the rows, so you'll have two entries for one and perhaps four for another. The pivot table would immediately show that.
