Comparing Several Arrays with Offset

Administrative Note:

Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect - 8 is not a version of Excel. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

For a start, I would NOT use OFFSET... it's volatile & best avoided:

=IF(SUMPRODUCT(--($B$7:$G$7=H7:M7))>0,"OK","Check")

and similar for the firrst 3 and for the last one:

=IF(SUMPRODUCT(($B$7:$G$7=H7:M7)*(B7:G7=N7:S7)*(B7:G7=T7:Y7))>0,"OK","Check")

Please try

=IF(MMULT(--(B7:G7=INDEX(H7:Y7,SEQUENCE(3,6))),SEQUENCE(6))=21,"OK","Check")

or with LAMBDA

=BYROW(INDEX(H7:Y7,SEQUENCE(3,6)),LAMBDA(z,IF(AND(z=B7:G7),"OK","Check")))

Why are you insistent on using a volatile function?

SUMPRODUCT will work perfectly on much larger data ranges.

What is the end result? a formula to compare block 1 to blocks 2,3,4,....50, or something like that??

One formula, copied down, to compare each block of 6 with the first one:

=IFERROR(IF(SUMPRODUCT(--($B$7:$G$7=INDEX($H$7:$Y$7,,1+6*(ROWS(B$9:B9)-1)):INDEX($H$7:$Y$7,,6+6*(ROWS(B$9:B9)-1))))>0,"OK","Check"),"")

Adjust the bits in red to suit your last datapoint

Welcome (back) to the forum.

Thanks for your question. However, we have just found out that you have posted the same question elsewhere.... and haven't told us. Feel free to cross-post on other sites...

But. Every forum has its rules. Please see Forum Rule #3 about cross-posting. So.

Do not keep it a secret. We all are willing to give you our time, freely. However, some of us get very annoyed if we waste our time developing a solution for you, when you already have a nice solution elsewhere. All we ask is that you show us some respect and tell us:

1) if you have cross-posted, and

2) the URL of the cross posts.

That way, those of us who don't want to waste their time can quickly check to see if you're already happy with another solution.

It is especially annoying that you cross-posted long AFTER two solutions have been offered here and you have not commented on EITHER of them.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Noted. However, you have still not responded regarding the suitability of either of the solutions offered (posts 7 and 9), despite being reminded by me to do so.