Thread: Lookup to return count, median, lower quartile, upper quartile&ave
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Lookup to return count, median, lower quartile, upper quartile
=MEDIAN(IF(x!A$2:A$1000=A2,x!C$2:C$1000))

Try adding the extra condition like this into the array:
=MEDIAN(IF((x!A$2:A$1000=A2)*(x!C$2:C$1000<""),x! C$2:C$1000))

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bee" wrote in message
...
HI Max,
Is there any way of excluding cells that are blank.All the UQ, LQ, Median
and average are being assessed across all the cells in the range.
Thanks
B


Reply With QuoteReply With Quote