Looking to Merge and Sum Duplicates from Multiple Fields
I have a Zoom report that lists attendees by their Display Name/Number and the Length of Time on the call. A new entry is added for each time an attendee joins or rejoins the call. In this instance, I have someone who has three call logs, that I’d like to merge and sum to get the total time spent on the call by the attendee.
Any advice on an efficient way to do this without going line by line?
I have a Zoom report that lists attendees by their Display Name/Number and the Length of Time on the call. A new entry is added for each time an attendee joins or rejoins the call. In this instance, I have someone who has three call logs, that I’d like to merge and sum to get the total time spent on the call by the attendee. Any advice on an efficient way to do this without going line by line? Read More