Hello,
I'm trying to be able to return data from two columns based on a value on the third. The list below shows a DM name, the employee ID number and their score. What I want to produce is a list where for each DM, I return the employee name and score based on the highest score. So in the data below for John, it should return employee 1777 and score 48.96%.
Thank you for any help!
<colgroup><col width="64" style="width: 48pt;" span="7">
<tbody>
</tbody>
I'm trying to be able to return data from two columns based on a value on the third. The list below shows a DM name, the employee ID number and their score. What I want to produce is a list where for each DM, I return the employee name and score based on the highest score. So in the data below for John, it should return employee 1777 and score 48.96%.
Thank you for any help!
DM | Employee | Score | DM | Employee | Score | |
Anton | 5232 | - | John | |||
Kyle | 1503 | - | Adam | |||
Steve | 1249 | - | CJ | |||
Monica | 2217 | 51.57% | Lisa | |||
Morgan | 8394 | 50.74% | Sarah | |||
John | 1777 | 48.96% | Amy | |||
Leo | 4281 | 47.01% | Kyle | |||
Kimberly | 1251 | 47.00% | Leo | |||
Bill | 1779 | 46.57% | Morgan | |||
Gilbert | 584 | 46.19% | Anton | |||
John | 1130 | 46.12% | Steve | |||
Jane | 1627 | 45.58% | Kimberly | |||
Amy | 1252 | 45.16% | Monica | |||
Anton | 1603 | 44.49% | Cindy | |||
Jane | 351 | 44.29% | Jane | |||
Leo | 2725 | 43.52% | Eddie | |||
Steve | 582 | 43.23% | Robert | |||
Eddie | 928 | 42.99% | Gilbert | |||
Sarah | 1739 | 42.93% | Matt | |||
Steve | 1749 | 42.62% | Bill |