| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trying to use the index function when #N/A can be part of data ran
I am using the index function to sample a range of data that will usually
contain several lines of #N/A data. The data is from an external app using DDE. In using the INDEX function I always get a #N/A result even when the INDEX is accessing valid rows of the range. If I remove the #N/A from the data range it works fine. Problem is I need to keep the range inclusive of any #N/A's it might be retrieving from the DDE. Any sugestions. -- Dan T. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index Function acceptig data from another sheet | New Users to Excel | |||
| Standard index form - Generating leading number (before *10^x part | Excel Worksheet Functions | |||
| how do i automate an index function with a data table | Excel Worksheet Functions | |||
| How to use cell data as part of hyperlink function | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Threaded Mode
