Thread: percentile - data in 2 different ranges
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Domenic[_2_] Domenic[_2_] is offline
external usenet poster
  
Posts: 265
Default percentile - data in 2 different ranges
In article ,
Idoia wrote:

I need to calculate a percentile, but my data is not organized as one single
array, but in 2 ranges.

I've tried things like:
=+PERCENTILE({A1:A4,D8:D11},0.9)
=+PERCENTILE({A1:A4;D8:D11},0.9)
=+PERCENTILE(A1:A4&D8:D11,0.9)
={+PERCENTILE(A1:A4&D8:D11,0.9)}

Nothing seems to work... Any ideas?

Thanks

Try...

=PERCENTILE((A1:A4,D8:D11),0.9)

--
Domenic
http://www.xl-central.com
Reply With QuoteReply With Quote