This can get rid of the NAs, but I can do that myself since I put them there
in the first place. What this still won't do is tell me (at any given row
with an NA) what is the next valid data value later down the column.

"Ron Rosenfeld" wrote:

On Sun, 15 Feb 2009 08:35:06 -0800, 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.

Could you use an Advanced Filter, and copy the good values to another range?

For example, with a label in A5 and your data in A6:An

Set up a two row (single column) criteria range someplace
Row1: Blank
Row2: =NOT(ISNA(A6))

(This assumes your NA is the Excel error value of #N/A)

Then select Data/Advanced Filter
List Range: A5:An
Criteria Range: Your two (2) row range as above
Select "Copy to Another Location"
Copy to: desired destination

<OK



--ron