Results 1 to 5 of 5

Duplicates in comparing two columns

Threaded View

  1. #1
    Registered User
    Join Date
    07-24-2007
    Posts
    4

    Duplicates in comparing two columns

    I am have a great deal of trouble. I have to compare over 10000 numbers between two columns. I cannot find a formula that will compare the two rows instead of comparing the information in just that one row. My point is say i have 10,000 numbers in one column and 10,000 in another column. I need to compare the two columns and make sure there are no duplicates between them. Can you help?? I have beensearching through threads and i cant find anything that works!

    ex:

    Col:A Col:B
    1 ---------7
    2 ---------8
    3 ---------9
    4 --------12
    5 --------2 *
    2 --------3 *
    3 --------15
    4 --------1 *
    5 ---------3 *
    6 ---------13

    how can i find these duplicates without looking through each one?
    Last edited by sammyd323; 07-26-2007 at 09:34 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1