Formula to check 2 ranges of cell values to see if each value is the same?

[danbates]

Hi,

I am after a formula that can check a range of values against another range of values individually to see if there is any difference in the cell values but I only want this formula to take up 1 cell.

I have found this formula online and it works up to a certain point.

=IFERROR(SUMPRODUCT(--(MATCH(C6:J6,C10:J10,0)>0))=COUNTA(C6:J6),FALSE)

The problem with this formula is, if I had 1 2 3 4 5 6 7 8 in C6:J6 and then I had the numbers in reverse 8 7 6 5 4 3 2 1 in C10:J10 the formula returns TRUE.

I would like the formula to return a FALSE if any of the ranges individual cells aren't exact.

Thanks

Dan

 

[Fluff]

How about

=SUMPRODUCT(--(C6:J6<>C10:J10))=0

 

[danbates]

Hi Fluff,

Perfect, thank you again.

Dan

 

[Fluff]

You're welcome & thanks for the feedback.