Changing a Filter Formula to VBA due to different Office Systems

[Brentsa]

Our work has Office 365 but due to needing IT Admin password we cannot update Office 365. I have the following Formula:

=FILTER('Difference Report (Historic)'!B7:M10000,(ROW('Difference Report (Historic)'!A7:A10000)-ROW('Difference Report (Historic)'!A6)+1)<=XMATCH("Inner Seal",'Difference Report (Historic)'!A7:A10000,0))

But as Filter does not work on a number of PC's is there a different formula to use or a VBA code I can use?

 

[mart37]

You can use SUMPRODUCT.

 

[Brentsa]

You can use SUMPRODUCT.

Thanks but can you explain more I have never used this before. How I will I change =FILTER('Difference Report (Historic)'!B7:M10000,(ROW('Difference Report (Historic)'!A7:A10000)-ROW('Difference Report (Historic)'!A6)+1)<=XMATCH("Inner Seal",'Difference Report (Historic)'!A7:A10000,0)) to a Sumproduct Formula?

 

[mart37]

If I'am not wrong you want to filter the rows lower then the row with "Inner Seal"

 

[Brentsa]

If I'am not wrong you want to filter the rows lower then the row with "Inner Seal"

The data that I'm working with is separated by the Row that has "Inner Seal" In this formula I'm looking for all rows that comes before "Inner Seals".
I do have another Formula that looks for all rows after "Inner Seals"

I want the results to appear in column aa3 of the same sheet "Difference Report (Historic)"

 

[mart37]

=IFERROR(IF(ROW($AA3)-2<=(SUMPRODUCT(--(ROW($A$7:$A$10000)-ROW($A$6)+1<=MATCH("inner seal",$A$7:$A$10000,0)))),INDEX($B$6:$M$10000,SUMPRODUCT((INDEX((ROW($A$7:$A$1000)-ROW($A$6)+1<=MATCH("inner seal",$A$7:$A$10000,0))*(ROW($A$7:$A$10000)-ROW($A$6)+1),ROW($AA3)-2))),COLUMN()-26),""),"")

Put this formula in AA3 and copy the cell to AK10000.