+ Reply to Thread
Results 1 to 4 of 4

Problem with array formula

  1. #1
    Forum Contributor
    Join Date
    08-29-2013
    Location
    CT
    MS-Off Ver
    Excel 2016 Mac
    Posts
    268

    Problem with array formula

    So i have a document with an array formula in it and i cannot seem to get it to work. It actually works for the first 60 records or so but not all of them.

    I have attached a sample document. the summary sheet and referral specifics sheet are not completing the formulas. It is making it to "L" and stopping there.

    I am sure it is a simple solution but i have been staring at it all day!!!

    Thanks LOS
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,635

    Re: Problem with array formula

    you need to extend your Referral data length
    'Referral Data'!$B$3:$B$102

    make it up to 205

    ie
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by humdingaling; 11-17-2014 at 10:36 PM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Contributor
    Join Date
    08-29-2013
    Location
    CT
    MS-Off Ver
    Excel 2016 Mac
    Posts
    268

    Re: Problem with array formula

    Fixed it thank you!!!

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,635

    Re: Problem with array formula

    not a problem

    may want to look into using named range for your formulas
    that way next time you need to amend the data you can do so in one place instead of every single formula

+ 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. Problem with Array Formula
    By TheRobsterUK in forum Excel General
    Replies: 4
    Last Post: 08-26-2010, 07:54 AM
  2. Array / CSE formula problem
    By benclayes in forum Excel General
    Replies: 8
    Last Post: 03-06-2010, 06:12 PM
  3. Problem w/Array Formula
    By danw in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2006, 06:00 PM
  4. [SOLVED] array formula problem
    By Richard Yates in forum Excel General
    Replies: 2
    Last Post: 09-30-2005, 08:05 PM
  5. array formula problem
    By bill gras in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-28-2005, 12:05 AM

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