Find next good data in a column
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.
|