derek.hughes
Board Regular
- Joined
- Mar 16, 2012
- Messages
- 53
This sheet has thousands of rows of data, but this is a "snippet" of what I am trying to accomplish.
<tbody>
</tbody>
I have employees that work in the same bargaining units, but under different pay classes. I essentially want a script that will:
In the example above it would leave behind the last two rows - by the way I do not need it to leave behind the summed total of the FTE, I just used that to explain how I want the Macro to decide which rows to remove.
Thanks!
Derek
Name | Bargain Unit | Pay Class | FTE |
John Doe | 220 | 15 | 0.05 |
John Doe | 220 | 15 | 0.10 |
John Doe | 220 | 15 | 0.10 |
John Doe | 220 | 20 | 0.50 |
John Doe | 220 | 20 | 0.25 |
<tbody>
</tbody>
I have employees that work in the same bargaining units, but under different pay classes. I essentially want a script that will:
- Figure out the Sum of the FTE, by Pay Class (Subtotal)
- Remove duplicates, leaving behind the rows with the LARGEST SUM of FTE
In the example above it would leave behind the last two rows - by the way I do not need it to leave behind the summed total of the FTE, I just used that to explain how I want the Macro to decide which rows to remove.
Thanks!
Derek