How to compare intervals?

I would do it this way.

Belowtheformulas:

First,Igiveanameforeachpair.

Then,Iconcatenatethenumbers(with-betweenthemnottomixandconfusethenumbers).

Then,Icopythenameofeachpairandtheconcatenatednumbersforacolumnandaline.

Finally,insidethetable,Icomparetheconcatenatedvalues.

Issue

Thereisnoneedfortheanswer,buttounderstandhowIdidthetable,ifyouwanttoreplicate.Anditcanbeausefulconcept.

TocopytherangeasIdid,forcolumnsEandFofthecomparisontable:

• SelectfromE4toF9;

• Typeequal(=);

• SelectfromB3toC8;

• Presscontrol+Shift+Enter.ThisinsertsanarrayincellsE4throughF9

ForthevaluesfromG2toL3: -SelectfromG2toL3;

• Type"=transpor(" (without quotation marks);

• Select from B3 to C8;

• Type ")" (without quotation marks) to close the formula transpor ;

• Press control + Shift + Enter. This inserts an array in cells G2 to L3, with the transposed (rotated) values of B3 to C8.

Using your specifications the "manual" way of doing what you want is:

D1 X D2 =$A$1=A2    =$A$2=A3
D1 X D3 =$A$1=A3    =$A$2=A4
D1 X D4 =$A$1=A4    =$A$2=A5
D1 X D5 =$A$1=A5    =$A$2=A6

D2 X D3 =$A$2=A3    =$A$3=A4
D2 X D4 =$A$2=A4    =$A$3=A5
D2 X D5 =$A$2=A5    =$A$3=A6

D3 X D4 =$A$3=A4    =$A$4=A5
D3 X D5 =$A$3=A5    =$A$4=A6

D4 X D5 =$A$4=A5    =$A$5=A6

Note that each line will compare the first element of Dx with the first element of Dy and the second element of Dx with the second element of Dy (where x and y are numbers 1 to 6 and y> p>

Each formula will give a FALSE or TRUE return. If necessary, you can use the E( ) formula to compare the results of the first and second elements to get a single boolean to know if both ranges are equal.

Another way to do this would be to create a function in VBA.