Find blank cells, calculate median

lilyeye Posts 1 Registration date Friday July 17, 2009 Status Member Last seen July 17, 2009 - Jul 17, 2009 at 08:28 PM
 New2Macros - Jul 28, 2009 at 11:33 AM

I have searched all over the forums looking for this without any luck, and I am rather new to macros, so I am hoping someone can help me. Here is my question:

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!


2 responses

pro-genius Posts 185 Registration date Tuesday November 18, 2008 Status Member Last seen January 29, 2010 68
Jul 18, 2009 at 04:52 AM
You only have to format cells, that the way to do it.
HI Lilyeye,

I am trying to do something similar. Let me know if you have any luck. I will do the same for you.