+ Reply to Thread
Results 1 to 2 of 2

Small and Array Formula

  1. #1
    Forum Contributor
    Join Date
    07-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    476

    Small and Array Formula

    Forgive me for not posting a workbook, but wondering if you've any thoughts, as this is my first time encountering this error.

    I have this ridiculous array formula to gather unique ID's that meet a given date:

    Please Login or Register  to view this content.

    If I index this in a cell, everything works fine. I get the requisite falses and the unique numbers as expected.

    Please Login or Register  to view this content.
    However, what I really want to do pull out unique Names, so I'm trying to get the smallest number of said names to no avail and getting an N/A error
    Please Login or Register  to view this content.
    Any thoughts? This is driving me crazy. I use this convention all the time without issue
    Last edited by cmore; 05-28-2015 at 10:56 AM.

  2. #2
    Forum Contributor
    Join Date
    07-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    476

    Re: Small and Array Formula

    So the problem is, I'm not that smart.

    the frequency and the conditional arrays aren't same amount of elements. If you iferror(array, false) on the first equation, then it works within the small(iferror(array,false),1)

+ 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. How Small Function works when small(array,1),small(array,2) are same ?
    By bkvenkat in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-02-2015, 02:00 AM
  2. [SOLVED] INDEX SMALL array formula issue
    By davepoth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-27-2013, 07:13 AM
  3. [SOLVED] Explanation of an array formula with SMALL()
    By wayusei in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-30-2013, 01:27 PM
  4. Replies: 2
    Last Post: 06-20-2012, 12:22 PM
  5. SMALL formula: array with non-adjacent cells
    By dvb_24 in forum Excel General
    Replies: 3
    Last Post: 06-07-2011, 02:44 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