Percentile Array Formula Limited to 25000 Rows?

Hi, I am using an Array formula (see below), which works fine unless I increase the last row number from 25000 to 25001. Is there a limit to how many rows can be used for an Array formula? I understand they are very inefficient and it's not recommended to use entire column references, which I had initially tried with no luck. My data set goes up to row 27445, which is why I started with the entire column reference - especially as the final row number will change as more data is added to the worksheet. I settled for entering specific cell references in the formula instead, but for some reason it will not work when entering a number over 25000!

=IFERROR(PERCENTILE(IF('Completed Orders'!$CG$2:$CG$25000='Table1'!G4,'Completed Orders'!$BP$2:$BP$25000),0.98),"")

The criteria for the Percentile formula is for cell G4 (a Concatenation) to match values in column CG (or $CG$2:$CG$25000) on the 'Completed Orders' worksheet. It must then return the 98th percentile of values in column BP, which are whole numbers. As stated, the formula works - I just want it to work for rows greater than 25000 as well! Thanks

OK I didn't explain that well! So, I will be using this same formula in other cells looking at G4, G5, G6, etc. all the way to G51. The IFERROR was purposefully put in to return a blank as some rows would not always return a value for the formula mentioned and I didn't want the table to be full of errors. For testing purposes, I've removed the IFERROR to see what returns when increasing the row numbers. The following formula returned '5', which is what I'd expect to see:

=PERCENTILE(IF('Completed Orders (E2E)'!$CG$2:$CG$25000=G4,'Completed Orders (E2E)'!$BP$2:$BP$25000),0.98)

When changing the row numbers from 25000 to 26000 (see below), it returns '#N/A'. There is data in both those columns up to row 27445 and there are no errors in either column, which often causes a subsequent error.

=PERCENTILE(IF('Completed Orders (E2E)'!$CG$2:$CG$26000=G4,'Completed Orders (E2E)'!$BP$2:$BP$26000),0.98)

Well I say there are no errors - just spotted one! Out of 27445 cells, there is one (CG25496) with an error, which explains why my percentile formula won't work for the entire column. I should have opened my eyes (sigh)!

Thanks

I also realised it didn't need to be an array formula. I saw someone recommend it on another post (don't ask which one) for a similar type of calculation, but it seems to work fine without. Unless you know why it may be beneficial/necessary to use array for this type of formula, i.e. PERCENTILE with multiple criteria? It now references the entire columns as well, e.g. $CG:$CG, so I assume it would just crash if using an array formula? I've heard they can be extremely slow!