example:
sheet 1: per firm the industry code in A and data in B (i omitted firmcode)
DNUM MULT1A
1000 1,361632912
1000 1,014911371
1000 1,844271002
1000 0,092151887
1000 0,533133521
1000 0,151594133
1000 0,712074691
1000 0,483009013
1040
1080
1080
........
........
sheet 2 is for the median value per industry
for code=1000 (cell A2)
using =MEDIANIF(sheet1!A2:A9;A2;sheet1!B2:B9)=
0,533133507
=MEDIAN(sheet1!B2:B9)= 0,622604106
the median(if()) function gives this answer also.
Since not all industry codes have enough data( i need at least 5) i want to
take medians of 100* or 10** as well. is this possible with a macro or
formula?
or shall i continue by hand
thnx in advance.
myra
" wrote:
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