Forum Discussion
Solved
Search for duplicates & sum
HI! I have exhausted my tech searches and am hoping someone can help me with this one. I have to add the minutes each employee spent in class for CPE certification. My spreadsheet shows each perso...
I'd create a pivot table based on the data.
Add the name field/column to the Rows area and the time field/column to the Values area.
See:
I'd create a pivot table based on the data.
Add the name field/column to the Rows area and the time field/column to the Values area.
See:
HansVogelaar Thank you! I do not know why I did not immediately think of a PivotTable, but it worked exactly as I needed it to. I appreciate your help.