Results 1 to 7 of 7

Comparing two groups of numbers

Threaded View

RalphJ Comparing two groups of... 07-01-2010, 09:33 PM
NBVC Re: Comparing two groups of... 07-01-2010, 10:08 PM
RalphJ Re: Comparing two groups of... 07-02-2010, 05:17 AM
RalphJ Re: Comparing two groups of... 07-02-2010, 06:28 AM
windknife Re: Comparing two groups of... 07-02-2010, 10:15 AM
RalphJ Re: Comparing two groups of... 07-02-2010, 02:31 PM
RalphJ Re: Comparing two groups of... 07-04-2010, 04:06 PM
  1. #1
    Registered User
    Join Date
    05-26-2010
    Location
    Brasil
    MS-Off Ver
    Excel 2007
    Posts
    10

    Comparing two groups of numbers

    Hello
    I am sure this is pretty simple but I can't seem to figure it out. I have two groups of numbers that I need to compare. One side of the list has about 8000 groups and the other side has about 640. They appear pretty much as follows

    02 05 07 11 12 14 17 21 other side 02 06 08 11 14 18 22 24

    The object is to match the numbers on the left to the numbers on the right as groups. The match has to be 100% or nothing.

    There is an equal number of digits on each side but they are in individual cells in the spreadsheet. If we can find a way to do this without the numbers being sorted it would be better. However, I can sort if it is needed.

    Any assistance will be much appreciated.

    Regards
    RalphJ
    Last edited by NBVC; 07-04-2010 at 04:25 PM.

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