+ Reply to Thread
Results 1 to 3 of 3

Assistance with Minimum Length array function

  1. #1
    Registered User
    Join Date
    05-08-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    10

    Assistance with Minimum Length array function

    I'm trying to find a way to discern the minimum length within an array. I need that value to preform certain search functions. The formula I'm attempting to use is: {=MIN(LEN(A1:A9))} This constantly fails me. I have tried searching around, but I'm not finding what I need to make this work. I'll attach my example workbook as a reference. As you can see the minimum length is the same formula all the way down, but each cell returns a value specific to the row number it is embedded in.

    Any help with this issue would be greatly appreciated.


    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Assistance with Minimum Length array function

    You need to enter the formula with CTRL+SHIFT+ENTER not just ENTER.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    05-08-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Assistance with Minimum Length array function

    Thank you very much! I knew that, I posted that in my question, but for whatever reason it didn't connect.

+ 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] Built-in-Function checking Array of Zero Length
    By Joakim N in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-17-2014, 04:37 AM
  2. [SOLVED] Getting minimum and maximum dates from a variable length range
    By ianbhenderson73 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-13-2013, 12:25 PM
  3. Replies: 3
    Last Post: 03-29-2012, 10:05 PM
  4. Array function for summing the minimum between two columns
    By shwayze24 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-03-2011, 12:24 PM
  5. [SOLVED] Modify array function length
    By Fabian Grodek in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-08-2006, 11:40 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