Okay, I have asked this before but can't seem to get it to work. I was wondering if anyone else had input. I have 2 worksheets called "stats" and "data".
On the data worksheet in column B, I have employee initials.
In column D, I have text either "TR" or "TO".
In column E, I have text either "yes" or "no"
On the "stats" worksheet, Column A is the employee initials.
In column B, total number of TO's for each employee.
In column C, total number of TR's for each employee.
In column D, the percent of TR's with yes's for each employee.
In column E, the percent of TO's with yes's for each employee.
How do I do this? Any help would be appreciated.
On the data worksheet in column B, I have employee initials.
In column D, I have text either "TR" or "TO".
In column E, I have text either "yes" or "no"
On the "stats" worksheet, Column A is the employee initials.
In column B, total number of TO's for each employee.
In column C, total number of TR's for each employee.
In column D, the percent of TR's with yes's for each employee.
In column E, the percent of TO's with yes's for each employee.
How do I do this? Any help would be appreciated.