Results 1 to 3 of 3

ISNA not working as expected

Threaded View

micco ISNA not working as expected 06-30-2011, 11:07 AM
NBVC Re: ISNA not working as... 06-30-2011, 11:25 AM
micco Re: ISNA not working as... 06-30-2011, 01:54 PM
  1. #1
    Registered User
    Join Date
    06-30-2011
    Location
    Portland, OR
    MS-Off Ver
    Excel 2010
    Posts
    2

    ISNA not working as expected

    I am trying to use an IF(ISNA formula to eliminate any #N/A entries from occurring in my sheet, but when I ctrl shift enter (array formula) none of the #N/As go away. The formula still works for the cells that return values, but it doesn't eliminate the #N/As. Any ideas? Here's the formula:

    =IF(ISNA(OFFSET(Table,0,MATCH("Commissioning Completion",OFFSET(Table,0,0,1,COLUMNS(Table)),0)-1,ROWS(Table),1)),"",(OFFSET(Table,0,MATCH("Commissioning Completion",OFFSET(Table,0,0,1,COLUMNS(Table)),0)-1,ROWS(Table),1)))
    Last edited by NBVC; 06-30-2011 at 03:57 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1