Good day again,
I need to find the Max volunteered hours for each unit. I believe this is going to be an array, but could someone help me put it together.
Data Table
<TBODY>
</TBODY>
The result table should look like
<TBODY>
</TBODY>
I may also need to figure out if 2 or more people from the same unit have the same amount of hours. If that is the case the result should be
<TBODY>
</TBODY>
I need to find the Max volunteered hours for each unit. I believe this is going to be an array, but could someone help me put it together.
Data Table
Unit | Employee | Total Volunteer Hours |
1 | a | 12 |
2 | a | 24 |
1 | b | 57 |
1 | c | 35 |
<TBODY>
</TBODY>
The result table should look like
Unit | Employee | Total Volunteer Hours |
1 | b | 57 |
2 | a | 24 |
<TBODY>
</TBODY>
I may also need to figure out if 2 or more people from the same unit have the same amount of hours. If that is the case the result should be
Unit | Employee | Total Volunteer Hours |
1 | b, d | 57 |
2 | a | 24 |
<TBODY>
</TBODY>