On Feb 15, 9:35*am, 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.

What is the formula you are using to cause the error, I don't use
xl'07 but I know it has a function called,
=iferror()
check it out...
http://exceltip.com/st/IFERROR_Funct...007_/1372.html

= IFERROR (yourFormula, "")