Re: Comparing two columns with email addresses

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Sandeep,

See Chip Pearson at:

Extracting Values Common To Two Lists
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates



---
Regards,
Norman


<sandeep_banga@xxxxxxxxxxx> wrote in message
news:1179845554.827571.36270@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,

I am trying to compare two columns that contain email addresses. The
goal is to identify email addresses that exist in both columns. I
tried VLOOKUP, and Countif functions but I can't get them to return
any results. I also did a copy and paste special (multiply) to make
sure the formatting in both columns is the same.

Column A has email addresses of people who read the email (total 168)
I sent out, and Column C has all the email addresses (total 1938) it
was sent to.

Can anyone please help?

Thank you!
Sandeep



.

Relevant Pages

  • Re: What are my options for dictionary hashing?
    ... their more common words with the letter 'A,' their next-most common ... The first is your assumption of 10 levels for 1024 deep vocabularies, ... then the most frequently used words in each hash string ... lists are ordered randomly. ...
    (comp.lang.forth)
  • Re: fastest sorted list type?
    ... I'm not aware of any scenario you've mentioned in which what you're sorting is "just an int". ... Yes, you have a scenario in which you are sorting a list of ints, but when you actually compare two entries in that list you aren't comparing the integers themselves, but rather the data in an object to which the int refers. ... I did have a look on google and wiki lists al the sort algorothms nicely, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: [fw-wiz] Re: Best Practices
    ... >of them, it is in getting others to link to those lists, read and then ... >frugallity have set the common mindset to; don't foot the bill till the ... target. ... My initial target would be admin and security people in small ...
    (Firewall-Wizards)
  • Re: [ANN][SoC] Ariel 0.1.0 released
    ... This is because of the way it checks for nesting when extracting label tags, ... Can Ariel correctly identify footnotes and pull in the text ... have:verses in your example above. ... lists with more than 5 children). ...
    (comp.lang.ruby)
  • Fuzzy comparison
    ... I'm trying to come up with a simple function that will allow me to compare ... long as they are within some tolerance but I also want the function to "act" ... total(but a weighted sum). ... compare two lists to see which one is "better". ...
    (sci.math)