I have a list of employees in a spreadsheet where I record if they paid their dues or not. I am looking for a formula solution to generate a list of employees that have paid. I understand this can easily be achieved by filtering, but in this particular case, I want to use a formula.
<tbody>
</tbody>
Desired result:
<tbody>
</tbody>
Thank you!
Employee Name | Paid due? |
Bobby Jones | No |
Richard Green | Yes |
Frank James | No |
Michelle Coolidge | No |
Allie Grayman | Yes |
Laura Finch | Yes |
Steve Heller | No |
Jason Richie | No |
Patty Jones | Yes |
Bill Musgrave | Yes |
Cameron Fuller | Yes |
Graham Yoland | No |
Katie Tegerine | No |
<tbody>
</tbody>
Desired result:
Richard Green |
Allie Grayman |
Laura Finch |
Patty Jones |
Bill Musgrave |
Cameron Fuller |
<tbody>
</tbody>
Thank you!