Comparing two groups of numbers

**RalphJ** · 07-01-2010, 09:33 PM

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

**NBVC** · 07-01-2010, 10:08 PM

What kind of comparison do you want to do?

**RalphJ** · 07-02-2010, 05:17 AM

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

**RalphJ** · 07-02-2010, 06:28 AM

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