Generate list of Unique Emails AND sum data in columns

[How2Excel?]

Hi Guys,

Fairly new to the forum, found it helpful for a quite few things but cant find an answer to this. I have a list of email address' each with a 'thread count' number attached, this list contain duplicates. I'm trying to generate a list of the unique email address' that also gives me the sum of thread count attached. For example if Person1 appeared three times each time with a thread count of 2, the unique list would have Person1 with a thread count of 6. Example workbook attached, thanks in advance

[Czeslaw]

Formula
Unique User Emails

Please Login or Register  to view this content.

Total Thread Count

Please Login or Register  to view this content.

[Glenn Kennedy]

Since you have O365, you can also use:

=UNIQUE($B$2:$B$21,FALSE)

for the email list.

[Shareez Saleem]

Unique list (A-Z Order)

Please Login or Register  to view this content.

Sum of thread count

Please Login or Register  to view this content.

[How2Excel?]

Thanks guys this worked a treat

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It would also be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.