Quote:
Originally Posted by Wodie
I have a list of 3288 items, I want to find the median of FCFY those items with a p/e value greater than one. There are 2 columns: p/e value and FCFY.
I think the formula should look like this but it doesn't work..
=IF(B4:B32881,MEDIAN(C4:C3288))
English: Find the median of C's value for all B's that are greater than 1.
Thanks for your help!!
|
Dear Wodie, Good Morning.
Try this one: =MEDIAN(IF(B4:B32881:C4:C3288))
This is a MATRICIAL FORMULA.
ATTENTION:
Don´t type ENTER after to type the fórmula.
TYPE: SHIFT + CTRL + ENTER
After it the formula will looks like this:
{=MEDIAN(IF(B4:B32881:C4:C3288))}
Teel me if it worked for you.
Fell free to ask anything about it.