hello,
I need help creating a median formula.
i have 2 worksheets on the worksheetA the user enters a list of names. on worksheetB is the data for these names. the function needs to get all the names search to see if they match on worksheet b and then take the values and return an median
this is the function i had used to return the average
=(DAVERAGE('2000'!$A$1:$CR$10650,$A3,Inputs!$B$9:$C$26))
200 is the name of the data table a1:cr10650 encompasses the complete table. A3 is the column refrence, inputs is the table where the names are listed and b9/c26 is that complete table..
=MEDIAN(IF(('1998'!$A$2:$A$10649=Inputs!$B$9:$B$26)*('1998'!$CS$2:$CS$10649=Inputs!$C$9:$C$26),''1998'!$B$2:$B$10649))
i was hoping this formula would replace the old one but it didnt work. basically i wanted this formula to see if there was a name in column a on the 1998 worksheet which matched the name on the inputs worksheet and if cs (Another field) matched c on the inputs worksheet and if it did to return b from 1998 and give me the median...
hope this is enough detail.. and not too much either...
PLEASE HELP
This message was edited by Judo Tom on 2002-09-06 11:22
I need help creating a median formula.
i have 2 worksheets on the worksheetA the user enters a list of names. on worksheetB is the data for these names. the function needs to get all the names search to see if they match on worksheet b and then take the values and return an median
this is the function i had used to return the average
=(DAVERAGE('2000'!$A$1:$CR$10650,$A3,Inputs!$B$9:$C$26))
200 is the name of the data table a1:cr10650 encompasses the complete table. A3 is the column refrence, inputs is the table where the names are listed and b9/c26 is that complete table..
=MEDIAN(IF(('1998'!$A$2:$A$10649=Inputs!$B$9:$B$26)*('1998'!$CS$2:$CS$10649=Inputs!$C$9:$C$26),''1998'!$B$2:$B$10649))
i was hoping this formula would replace the old one but it didnt work. basically i wanted this formula to see if there was a name in column a on the 1998 worksheet which matched the name on the inputs worksheet and if cs (Another field) matched c on the inputs worksheet and if it did to return b from 1998 and give me the median...
hope this is enough detail.. and not too much either...
PLEASE HELP
This message was edited by Judo Tom on 2002-09-06 11:22