Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Location
    Colorado
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Comparing columns in Excel (2002)

    I am trying to compare 2 columns in Excel to see if there are any duplicate cells. Can this be done and if so how?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comparing columns in Excel (2002)

    See if <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=58391&page=&v iew=&sb=&o=&vc=1#Post58391>This Thread</A> will help.
    Legare Coleman

  3. #3
    New Lounger
    Join Date
    Jan 2002
    Location
    Colorado
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comparing columns in Excel (2002)

    That's perfect, thanks for the quick answer. I've been trying to figure this out for days.

  4. #4
    New Lounger
    Join Date
    Jan 2002
    Location
    china
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comparing columns in Excel (2002)

    You can use "Data---get external data" SQL query function to do it,
    like " select col1,col2
    from excel1
    where col1<>col2
    and col1 is not null"
    if this query have something detail data can return excel sheet , means col1 <> col2.

    you can make it to a excel macro....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •