+ Reply to Thread
Results 1 to 4 of 4

Please help Array formula not working

  1. #1
    Registered User
    Join Date
    10-30-2013
    Location
    Boise, ID
    MS-Off Ver
    Excel 2010
    Posts
    36

    Please help Array formula not working

    So I have a spreadsheet I am creating. I can not get my array formula to work correctly. I have a handout list on sheet one, and on sheet two I want excel to decipher when I need to update my handout. I can get it to read the first handout of the month, but it is not bringing over the remaining handouts. Can someone please look at my formula and tell me what is wrong? I know I am close.



    thanks
    Lola
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Please help Array formula not working

    Your formula works as intended, provided you commit by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

    To hide the #NUM! errors use:
    Please Login or Register  to view this content.
    Last edited by protonLeah; 02-27-2017 at 04:54 PM.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    10-30-2013
    Location
    Boise, ID
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Please help Array formula not working

    Thank you! I knew I was really close!

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Please help Array formula not working

    Here's a better way to write that formula...

    =IFERROR(INDEX('Handout List'!$C:$C,SMALL(IF('Handout List'!$B$3:$B$93=A$2,ROW('Handout List'!$B$3:$B$93)),ROWS(A$1:A1))),"")

    Still array entered!
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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 Theodjinn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2008, 04:09 AM
  3. Array formula not working - Please Help
    By BS_Watson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2007, 03:05 PM
  4. [SOLVED] Array formula not working
    By bj in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 07:05 AM
  5. [SOLVED] Array formula not working
    By bj in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM

Tags for this Thread

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