Posted to microsoft.public.excel.worksheet.functions

joeu2004[_2_] joeu2004[_2_] is offline

external usenet poster

Posts: 829

median array help

"tmason" wrote:
this formula made into an array is not excluding empty cells.
Any ideas?
{=MEDIAN(IF(A$2:A$50000=A2,IF(B$2:B$50000=B2,C$2:C $50000)))}

Array-enter the following formula (press ctrl+shift+Enter, not just Enter):

=MEDIAN(IF(A$2:A$50000=A2,IF(B$2:B$50000=B2,
IF(C$2:C$50000<"",C$2:C$50000))))

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
Median Array	[email protected]	Excel Worksheet Functions	4	April 9th 08 01:34 PM
Calculating Median Value in a large array	willcozz	Excel Discussion (Misc queries)	5	December 11th 06 10:21 PM
Median array formula	Ciara	Excel Worksheet Functions	1	October 4th 06 10:55 AM
MEDIAN() as array function?	Henrik	Excel Worksheet Functions	6	October 11th 05 11:35 PM
Median of an Array	Kris Taylor	Excel Programming	1	November 11th 03 12:21 AM

All times are GMT +1. The time now is 11:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us