Posted to microsoft.public.excel.misc

Idoia

external usenet poster

Posts: 29

percentile - data in 2 different ranges

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display Percentile	BLR	Excel Worksheet Functions	6	December 4th 08 10:21 PM
Use excel to calculate a percentile from data in multiple sheets	EmyG	Excel Worksheet Functions	0	July 24th 07 03:40 AM
to get its k-value from percentile and array	Peter	Excel Worksheet Functions	3	March 22nd 07 02:46 PM
Returning all data from a list above the nth percentile	chlor	Excel Worksheet Functions	11	February 22nd 06 01:28 PM
percentile	Blessingspoint	Excel Worksheet Functions	2	January 22nd 05 06:19 AM

All times are GMT +1. The time now is 03:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us