Hi,

Next good row after which NA? The first NA, the last NA? Is a blank "good
data", or does it have to be a number or text or eitner or a data or...

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"rocket" wrote:

I have a column in my worksheet with many #N/A entries. I'm looking for a
function which will return the next "good" (non #N/A) data value from a later
row in that column. I want to save that to the row with the bad data, so I
cannot filter out all the NA rows. I've got Excel-2007.

Here's an example:
1: 3
2:NA
3:NA
4:NA
5:6
6:12
What I actually want to do is interpolate rows 2-4 based on values in a
different column. I think I can do the interpolation part, if I could just
get past the NAs.The problem is that in row 2, I can't figure out how to look
for row 5 to get the next good data point.

The NAs were my creation, so if it would make the function easier, I could
make all the NAs be "" or "BAD". All the other data are numbers.

"Shane Devenshire" wrote:

Hi,

Next good row after which NA? The first NA, the last NA? Is a blank "good
data", or does it have to be a number or text or eitner or a data or...

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"rocket" wrote:

I have a column in my worksheet with many #N/A entries. I'm looking for a
function which will return the next "good" (non #N/A) data value from a later
row in that column. I want to save that to the row with the bad data, so I
cannot filter out all the NA rows. I've got Excel-2007.