Diving_Dan
Board Regular
- Joined
- Oct 20, 2019
- Messages
- 161
Hi all,
I have a data report that gives figures for individual employees. For whatever reason when I am being provided with the report I am getting multiple rows of data for one employee.
Column A has the employee ID, and then Columns B onward hold figures to do with the employee's productivity.
What I am trying to achieve is to loop through all cells in column A, and for each cell look to see if there are any other cells with the same range that have the same employee ID. If there are I only want 1 row of data for that Employee ID so would need to sum columns B, C, D etc and then remove duplicates. I hope that makes sense. Any help is appreciated as always.
Dan
I have a data report that gives figures for individual employees. For whatever reason when I am being provided with the report I am getting multiple rows of data for one employee.
Column A has the employee ID, and then Columns B onward hold figures to do with the employee's productivity.
What I am trying to achieve is to loop through all cells in column A, and for each cell look to see if there are any other cells with the same range that have the same employee ID. If there are I only want 1 row of data for that Employee ID so would need to sum columns B, C, D etc and then remove duplicates. I hope that makes sense. Any help is appreciated as always.
Dan