Comparing email lists

talk random
1

hey! This is my problem, I have 2 lists of emails, one with 1400 and another one with more! I need to compare both, see how many are repeated and make one list, but I dont want to go one by one :expressionless: any ideas how to check both lists and make one??

Thanks!

2

either use a database or excel. actually, i would use excel and it would take 2 seconds. enter all of them in same column (A). then in B1, type =LOWER(A1). if i were concerned about whitespaces before or after the e-mail, i would use =TRIM(LOWER(A1)). then fill that all the way down. highlite column B , data>filter>advanced filter>unique records only. booyakasha.

3

thanks man! Problem resolved :slight_smile:

4

no problem. glad to help.