Hello,
I am attempting to create a list of employees who finished reports on time. My issue is that my data sources have different interpretations of their name.
I'll give an example.
In Sheet 1:
<tbody>
</tbody>
In Sheet 2:
<tbody>
</tbody>
My current formula looks like:
Which is not returning anything.
I know the issue lies in the partial name match.
Any suggestions?
Thanks!
I am attempting to create a list of employees who finished reports on time. My issue is that my data sources have different interpretations of their name.
I'll give an example.
In Sheet 1:
Employee | % Reports Completed on Time |
Hubert Humphrey | |
Mary Shelley | |
Fats Domino |
<tbody>
</tbody>
In Sheet 2:
Employee | Report completed on time? |
Humphrey | No |
Shelley | Yes |
Humphrey | Yes |
Domino | No |
Shelley | No |
Domino | Yes |
Domino | Yes |
<tbody>
</tbody>
My current formula looks like:
Code:
=IF("*"&Sheet2[Employee]&"*"=Sheet1!A2,COUNTIF(Sheet2[Report completed on time?],"yes")/SUM(COUNTIF(Sheet2[Report completed on time?],"yes"),COUNTIF(Sheet2[Report completed on time?],"no")),"")
Which is not returning anything.
I know the issue lies in the partial name match.
Any suggestions?
Thanks!