Jul 07 2020 09:53 AM
Hi There,
Looking for help. Have a list of Employee #s and when there is a duplicate, I would like to sum the hours in Column K and return the total in a New Column. all the better if it can also delete one of the duplicate rows in doing so, so I am left with a Total that corresponds to the one employee. Attached is a data sample and desired outcome example.
Jul 07 2020 10:35 AM
@emilyexcel Please find attached solution
If you are satisfied with the solution do mark this solution as best and official solution.
Jul 07 2020 10:38 AM
SolutionIf you delete the empty columns from your data set, you may insert a Pivot Table to get the data in desired format.
Refer to the attached and look at the sheet called "Pivot Table" for more details.
Jul 07 2020 10:44 AM
Jul 07 2020 10:58 AM
You're welcome @emilyexcel!
Jul 07 2020 10:38 AM
SolutionIf you delete the empty columns from your data set, you may insert a Pivot Table to get the data in desired format.
Refer to the attached and look at the sheet called "Pivot Table" for more details.