Hey guys,
The following array formula returns 0. Any Ideas why?
=MEDIAN(IF('textexport(1)'!$O:$O=Sheet3!A2,'textexport(1)'!$P:$P,))
Since pivot tables do not have a median option I have all the days (1/1/2005-12/31/2011) in column A and want the median for each. If anyone has a suggestion...