Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find next good data in a column
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare data in column A with column B to find duplicates | Excel Discussion (Misc queries) | |||
Duplicates are GOOD: How to find the most duplicated values? | Excel Worksheet Functions | |||
Good at Macros? I'm Trying to find duplicate entries. | Excel Discussion (Misc queries) | |||
Worksheet looks good in print, not so good on-screen | Excel Discussion (Misc queries) | |||
Does anyone know where I can find a good excel template for track. | Excel Discussion (Misc queries) |