+ Reply to Thread
Results 1 to 7 of 7

Comparing two groups of numbers

  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.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Comparing two groups of numbers

    What kind of comparison do you want to do?
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    05-26-2010
    Location
    Brasil
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Comparing two groups of numbers

    Thanks NVBC

    I want to know if the all the numbers on the left equals all the numbers on the right. NOT number by number but as groups.

    Thanks Again
    RalphJ

  4. #4
    Registered User
    Join Date
    05-26-2010
    Location
    Brasil
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Comparing two groups of numbers

    Here is a better example of what I need

    Let me try again: I will leave the zero's in fromnt of the numbers for spacing only. In the comparision the leading zero's are not important.

    Left Side
    1L. 01 02 05 07 11 14 18 21
    2L. 09 08 12 11 13 18 19 25
    3L. 03 06 13 11 19 21 23 24

    Right Side
    1R. 07 09 01 11 12 15 16 21
    2R. 01 02 05 07 14 11 18 21
    3R. 12 11 02 05 09 07 16 25

    In the above example 1L and 2R match. You will notice they are not in sequential order but all numbers match.

    Thanks

    Ralph

  5. #5
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,873

    Re: Comparing two groups of numbers

    About the attached. Your original data is in the sheet1.
    You can see formula in the sheet2.

    HTH,
    windknife
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    05-26-2010
    Location
    Brasil
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Comparing two groups of numbers

    Thanks Windknife

    I will take a look at this and see if I can understand it

    RalphJ
    Last edited by RalphJ; 07-04-2010 at 04:07 PM. Reason: [SOLVED]

  7. #7
    Registered User
    Join Date
    05-26-2010
    Location
    Brasil
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Comparing two groups of numbers

    Quote Originally Posted by ralphj View Post
    thanks windknife

    i will take a look at this and see if i can understand it

    ralphj
    [solved]_04/07/2010

+ Reply to Thread

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