# Comparing email lists **URL:** \ **Category:** random\ **Created:** [April 6, 2006, 6:40pm UTC](https://forum.kirupa.com/t/comparing-email-lists/184671 "2006-04-06T18:40:35Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![berkoWitZ](https://avatars.discourse-cdn.com/v4/letter/b/b9bd4f/32.png) [@berkoWitZ](https://forum.kirupa.com/u/berkoWitZ)\ **Post date:** [April 6, 2006, 6:40pm UTC](https://forum.kirupa.com/t/comparing-email-lists/184671/1 "2006-04-06T18:40:35Z")
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 😑 any ideas how to check both lists and make one?? Thanks! ---
**Author:** ![bwh2](https://avatars.discourse-cdn.com/v4/letter/b/8c91f0/32.png) [@bwh2](https://forum.kirupa.com/u/bwh2)\ **Post date:** [April 6, 2006, 6:55pm UTC](https://forum.kirupa.com/t/comparing-email-lists/184671/2 "2006-04-06T18:55:01Z")
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. ---
**Author:** ![berkoWitZ](https://avatars.discourse-cdn.com/v4/letter/b/b9bd4f/32.png) [@berkoWitZ](https://forum.kirupa.com/u/berkoWitZ)\ **Post date:** [April 7, 2006, 2:04am UTC](https://forum.kirupa.com/t/comparing-email-lists/184671/3 "2006-04-07T02:04:33Z")
thanks man! Problem resolved 🙂 ---
**Author:** ![bwh2](https://avatars.discourse-cdn.com/v4/letter/b/8c91f0/32.png) [@bwh2](https://forum.kirupa.com/u/bwh2)\ **Post date:** [April 7, 2006, 2:30am UTC](https://forum.kirupa.com/t/comparing-email-lists/184671/4 "2006-04-07T02:30:12Z")
no problem. glad to help.