+ Reply to Thread
Results 1 to 5 of 5

Array formula is now not working

  1. #1
    Forum Contributor
    Join Date
    06-10-2014
    Location
    UK
    MS-Off Ver
    2010
    Posts
    272

    Array formula is now not working

    Can anyone see any errors in this array formula ?

    I had it working sometime ago, but just tried again and it returns a blank cell.

    =IFERROR(LOOKUP(2,1/(SMALL(IF('[Sales 2016.xlsm] Nc Orders'!$K$13:$K$206<>"",'[Sales 2016.xlsm] Nc Orders'!$K$13:$K$206+'[Sales 2016.xlsm] Nc Orders'!$L$13:$L$206),ROW(A1))=IF('[Sales 2016.xlsm] Nc Orders'!$K$13:$K$206<>"",'[Sales 2016.xlsm] Nc Orders'!$K$13:$K$206+'[Sales 2016.xlsm] Nc Orders'!$L$13:$L$206)),'[Sales 2016.xlsm] Nc Orders'!$B$13:B$206),"")

    Thanks

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Array formula is now not working

    Try to change $206 to longer, i.e 1000
    Quang PT

  3. #3
    Forum Contributor
    Join Date
    06-10-2014
    Location
    UK
    MS-Off Ver
    2010
    Posts
    272

    Re: Array formula is now not working

    I did change as you suggest, but can't see why that would make any difference.

    Result is the same

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Array formula is now not working

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Array formula is now not working

    It looks OK to me. I simplified it to a single sheet and it seems to work. you did use Ctrl-Shift-enter and not just enter, didn't you???
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Array Formula Not Working....
    By sagar007 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-09-2012, 01:16 AM
  2. Array formula not working
    By MIAO in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-31-2012, 10:01 AM
  3. Array formula not working
    By Theodjinn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2008, 04:09 AM
  4. Array formula not working - Please Help
    By BS_Watson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2007, 03:05 PM
  5. Array formula not working
    By Alex in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-14-2005, 07:28 PM

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