Column A has list of employee names (some repeating multiple times)
Column B has yes or no
A -----B
Name1 yes
Name1 yes
Name no
Name2 no
Name2 yes
Name3 no
Name3 no
Name3 yes
I need to return a percentage (of yes') for each employee.
I want to match or recognize the name in column 1, then calculate the percentages for all of that employee's yes' or no's.
Right now I'm using this:
=COUNTIF(A1:A5,"YES")/COUNTA(A1:A5)
But this fails to help me, as I count the rows, looking to see how many rows each employee fills (eg, A1:A5) and the actual spreadsheet I'm working on has 3000+ lines...
Bookmarks