Forum Discussion

culm's avatar
culm
Copper Contributor
Jul 18, 2017

Comparing 2 Columns of Data in Excel

I have two columns of email addresses.  I want to identify (but not remove) any email addresses that are in both columns.  Any advice greatly appreciated!  Charles

4 Replies

    • culm's avatar
      culm
      Copper Contributor
      All good now thanks Logaraj.
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Hello

     

    This is a frequently asked task and there are about 59 millions Google hits to choose from.

    Hit #1.

    • culm's avatar
      culm
      Copper Contributor
      Success! Thanks for the advice.