Hi,
I need urgent help to develop a formula for the following:
I have an extremely large data set, approximately 600,000 rows. There are a number of variables that need to be considered but basically I need to delete positive and negative numbers (hours paid) per employee (employee id), per date (date of leave). I am pretty good with excel but this one is hurting! Appreciate any suggestions!
<tbody>
</tbody>
I need urgent help to develop a formula for the following:
I have an extremely large data set, approximately 600,000 rows. There are a number of variables that need to be considered but basically I need to delete positive and negative numbers (hours paid) per employee (employee id), per date (date of leave). I am pretty good with excel but this one is hurting! Appreciate any suggestions!
Employee ID | Leave Type | Date of Leave | Hours Paid |
123 | Sick Leave | 01/01/2000 | 7.5 |
123 | Sick Leave | 01/01/2000 | -7.5 |
123 | Rec Leave | 02/02/2001 | 10.00 |
456 | Rec Leave | 13/02/2001 | 8.00 |
456 | Sick Leave | 13/02/2001 | -8.00 |
789 | Family Leave | 01/01/2000 | 8.00 |
789 | Family Leave | 02/01/2000 | 8.00 |
789 | Family Leave | 03/01/2000 | 8.00 |
789 | Family Leave | 04/01/2000 | 8.00 |
<tbody>
</tbody>