for my thesis i need to create median industry multipliers. i have a list of
companies with their industry codes and multiples, but now i need to create a
list with medians per industry. is there a function similar to SUMIF for
medians?

Hello,

Look he
http://www.bettersolutions.com/excel...N616805002.htm

HTH,
Bernd

i have tried MEDIAN(IF(SHEET1!A2:A100=SHEET2!A2;SHEET1!B2:B100) )
but it returns either a zero or a #value. even though there is a match the
formula returns false.

entering the matching industry codes in the formula e.g. "100" does not work
either.
do i need to adjust cell format (now"'general")?

thanx.




" wrote:

Hello,

Look he
http://www.bettersolutions.com/excel...N616805002.htm

HTH,
Bernd

Hello Myra,

Did you really enter that formula as array formula (not only ENTER but
CTRL + SHIFT + ENTER)?

Regards,
Bernd

Thank you. took awhile to get the hang of it.
i've been trying the custom function method (since i have to create 300
medians)

but why does the MEDIANIF() function differ from the hands on median formula?
any ideas how i can use the MEDIANIF function to match on the first 3 digits
only and then take a median value?

ciao






" wrote:

Hello Myra,

Did you really enter that formula as array formula (not only ENTER but
CTRL + SHIFT + ENTER)?

Regards,
Bernd

Hello,

If given the same data these functions should not differ.

Could you give a short example how your industry codes and your data
look like?

Either post it here (anonymous data only) or send me an email.

Regards,
Bernd

Looks like this link is no longer valid...

" wrote:

Hello,

Look he
http://www.bettersolutions.com/excel...N616805002.htm

HTH,
Bernd