Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dealing with #N/A results
Is there a way to replace all the #N/A results from any formula? If you try
to use #N/A in the replace function, Excel doesn't recognize it. The only work around I could come up with is to sort the column with the #N/A's and then delete or copy over them. Thanks, Sandy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to pick Home and Away results from a list | Excel Worksheet Functions | |||
Paste results consecutively within column (based off other worksheet) | Excel Worksheet Functions | |||
abdualmohsn | Excel Discussion (Misc queries) | |||
Date stamp formula results? Tricky problem? | Excel Discussion (Misc queries) | |||
calculating results in formulas | Excel Discussion (Misc queries) |