Find blank cells, calculate median

Closed
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
Hello,

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!

Beth

2 replies

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.
1
HI Lilyeye,

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