R
reno
Using XL 07, want to calculate median.
have worksheet of census data by zipcode that makes displays data within 25
miles of inputted zipcode. these may range from 20 to nearly 60 zipcodes.
one field is median hshld income.
once the zips w/in 25 are identified, a macro sorts the distances in
ascending order and places an "X" in the 25 mile column, several calcualtions
are made for summing or other math using <if (AK9=X, then....) and so forth>
unable to determine how to calculate a median of median hshld incomes when
the number of included zips varies.
another view would be a macro: starting in row 9 and continue down and
perform median calc until AKxx no longer ="X", if that makes sense.
thanks
have worksheet of census data by zipcode that makes displays data within 25
miles of inputted zipcode. these may range from 20 to nearly 60 zipcodes.
one field is median hshld income.
once the zips w/in 25 are identified, a macro sorts the distances in
ascending order and places an "X" in the 25 mile column, several calcualtions
are made for summing or other math using <if (AK9=X, then....) and so forth>
unable to determine how to calculate a median of median hshld incomes when
the number of included zips varies.
another view would be a macro: starting in row 9 and continue down and
perform median calc until AKxx no longer ="X", if that makes sense.
thanks