Find blank cell, insert formula to find median of above cell range

Hi

I am trying to find medians for a series of values (in a column) separated by blank rows where the formula knows to end the median calculation when it runs into the first blank cell--and the median number will be calculated in this blank cell.

For instance, cells O3:O15 are filled in, O16 is blank, I want a code that can find the blank O16 cell, and in that cell calculate the median of O3:O15.

I have about 150,000 rows, and there is not a uniform spacing between the blank cell ranges.

thanks in advance!

Beth

You don't need code to do this. Just need a couple of tricks

1. highlight the the cells containing all the data (ie A1:A200). Make sure that the last cell in your selection is the last blank cell).
2. Use the command GOTO\SPECIAL\BLANKS (press F5 to bring up the GOTO Dialogue)
3. Then use the AutoSum button and select the average function.

that should do what you want

This trick works only if there is only one blank cell, unless Im doing something wrong. Can we make it work when there are more than one empy cell.

Thanks in advance