+ Reply to Thread
Results 1 to 4 of 4

Array formula Not Working - Help

  1. #1
    Forum Contributor
    Join Date
    04-18-2016
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    139

    Array formula Not Working - Help

    Dear All,

    I am try to extract the data using the below formula, but it is not working. Sample file attached...

    {=IFERROR(INDEX('CR Tracker'!D$3:D$646,SMALL(IF('CR Tracker'!AC$3:AC$646>=Report_Summary!$D$2)*('CR Tracker'!AC$3:AC$646<=Report_Summary!$F$2)*(Report_Summary!=$D$4),ROW(Report_Details!$B$6:$B$200)-ROW(Report_Details!$B$6)+1," "),ROWS(Report_Details!$B$6:H6))),"")}

    Please help.

    Gem
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    20,742

    Re: Array formula Not Working - Help

    Try

    =IFERROR(INDEX('CR Tracker'!D$3:D$646,SMALL(IF(('CR Tracker'!AC$3:AC$646>=Report_Summary!$D$2)*('CR Tracker'!AC$3:AC$646<=Report_Summary!$F$2)*('CR Tracker'!F$3:F$646=Report_Summary!$D$4),ROW('CR Tracker'!D$3:D$646)-ROW($D$3)+1," "),ROWS($D$3:D3))),"")


    Plus make ranges consistent

    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    04-18-2016
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    139

    Re: Array formula Not Working - Help

    Thanks a lot John.. It's working perfectly...

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    20,742

    Re: Array formula Not Working - Help

    Thank you for the feedback and rep.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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
    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