I have employee initials in Col B
In column D I have text consisting of either TR or TO.
In Column E, I have text: containing YES or No.
I want on a seperate sheet to total the number of TO'S and TR'S for each employee.
Also give a percentage of the number of TO YES'S and the percentage of TR YES'S.
Any help would be appreciated
In column D I have text consisting of either TR or TO.
In Column E, I have text: containing YES or No.
I want on a seperate sheet to total the number of TO'S and TR'S for each employee.
Also give a percentage of the number of TO YES'S and the percentage of TR YES'S.
Any help would be appreciated