.. This didn't however give the correct result?
well, I got the correct results as illustrated in my test/sample,
link to it here for your easy reference:
http://www.freefilehosting.net/download/3f127
Median Excluding Certain Dates.xls
(I actually framed it up to closely suit what you indicated in your original
post)
Maybe try checking at your end:
- is the expression correctly array-entered? (see the curlies { } in the
formula bar)
- are the values in your col D all real dates?
- are the values in your BankHol defined range all real dates?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
<matthew.... wrote
I array entered the following
=MEDIAN(IF((ISERROR(MATCH($D$3:$D$134,BankHol,0))* ($D$3:$D$134<"*")),
$E$3:$E$134))
Column D= dates
Column E= data
BankHol= named range of dates to be excluded from median calc
This didn't however give the correct result?
Cheers
Matt