+ Reply to Thread
Results 1 to 4 of 4

2 array formula, same principle 1 work, 1 doesnt

  1. #1
    Forum Contributor
    Join Date
    10-28-2010
    Location
    quebec, canada
    MS-Off Ver
    o365
    Posts
    187

    2 array formula, same principle 1 work, 1 doesnt

    Hey guys,

    I've got this weird problem...

    Formula 1:

    Please Login or Register  to view this content.
    Formula 2:

    Please Login or Register  to view this content.
    Both are array formula.
    formula 1 works fine
    formula 2 is almost identical BUT fails. it will bring me one of the right results if i DO NOT use the array. I need to make it in a array so more than 1 result can be provided. (ctrl-alt-enter).. the second i make an array, results disappear.

    I know where the error kicks in
    Please Login or Register  to view this content.
    Because if i change the M:M back to formula 1, suddendly the array works. But not if i add >1<=3 and ctrl alt enter it.

    It is like it does understand my logical value, but loose it when i transform it in an array.

    Any clues?

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: 2 array formula, same principle 1 work, 1 doesnt

    (Tracker!M:M>1<=3) Is not correct syntax.

    Should be...
    (Tracker!M:M>1)*(Tracker!M:M<=3)
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: 2 array formula, same principle 1 work, 1 doesnt

    Hey,

    I don't think Excel know what you mean by:

    >1<=3

    What does this mean?
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Forum Contributor
    Join Date
    10-28-2010
    Location
    quebec, canada
    MS-Off Ver
    o365
    Posts
    187

    Re: 2 array formula, same principle 1 work, 1 doesnt

    Oh man ... long day...

    Thanks everyone, i know my answer was super simple. :P

+ 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] How to get a VLOOKUP+MATCH formula to return 0 and not N/A when MATCH doesnt work
    By Renejorgensen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2016, 09:40 AM
  2. [SOLVED] Formula for SUMIFS horizontal DOESNT WORK
    By vba1234 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-04-2016, 12:54 PM
  3. Formula doesnt work until the date
    By monkeytusmc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-31-2015, 02:49 AM
  4. [SOLVED] iferror formula for copying variables under certain conditions doesnt work
    By kronikjb in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-31-2015, 02:48 AM
  5. [SOLVED] any Ideas Why this INDEX MATCH formula doesnt work ?
    By ecelaras in forum Excel General
    Replies: 13
    Last Post: 11-30-2012, 06:55 AM
  6. Principle Formula
    By cwiesniewski in forum Excel General
    Replies: 6
    Last Post: 05-07-2012, 07:53 PM
  7. Formula doesnt work
    By Kevin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-23-2005, 09:06 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