PERCENTILE.EXC across multiple tabs

Hi All,

I am dealing with a large data set. Just wanting to see how I can expand the PERCENTILE.EXC across multiple tabs. Currently it only allows one set of array.

At the moment it's looking like =PERCENTILE.EXC('Pump Telemetry'!$B$2:$B$1048576,0.99).

I have 4 additional tabs (Pump Telemetry 2, Pump Telemetry 3, Pump Telemetry 4, Pump Telemetry 5).

Please help.

And do you have 1048576 rows of data on at least 3 of those sheets??? If not, roughly how many rows per sheet MAXIMUM?

I have tested this on a sheet with 1,000,000 random numbers per sheet. This SEEMS to work OK...

=PERCENTILE.EXC(CHOOSE({1,2,3,4},Sheet1!$A$1:$A$1000000,Sheet2!$A$1:$A$1000000,Sheet3!$A$1:$A$1000000,Sheet4!$A$1:$A$1000000),0.99)

Needless to say I can not attach such a large file here. If you need... drop me a PM with your email address and I'll email it to you (.xlsb ~ 26 Mb)

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.