Data Analysis question

Hello everyone. Long time user first time poster.

I am importing a CSV and analyzing some data, but i got stuck on 1 part. I usernames in Column A and the time they spent logged in in Column B. Column A has recurring users and i was able to consolidate that through sets. But how do I add the time for each user aggregated from Column A without any repetition?

Thank you for your help!

Replies are closed for this discussion.

Replies to This Discussion

Permalink Reply by Hiram Boujaoude on October 22, 2017 at 12:20am

basically this but with GH https://www.extendoffice.com/documents/excel/1268-excel-combine-dup...

Permalink Reply by Noam Yorke on October 22, 2017 at 4:32am

Try using the set you made to make a pattern for every user. then use that pattern to select the relevant times in b. use mass addition and you should be good.

Also upload a file so people can see your work and understand the problem. Noam

Permalink Reply by Joseph Oster on October 22, 2017 at 5:23am