+ Reply to Thread
Results 1 to 9 of 9

I am stumped on array formulas

  1. 09-06-2014, 05:30 PM #1
    kevin316
    kevin316 is offline
    Registered User
    Join Date
    09-28-2009
    Location
    Alberta Canada
    MS-Off Ver
    Excel 2003
    Posts
    41

    I am stumped on array formulas

    I have tried every everything on my mac that I can think of but I can't make a formula an array.

    I have tried cnt, cmd enter
    fn cmd enter
    com enter
    option enter

    Everything in between. What am I missing?

    Here is the formula
    =INDEX($F$4:$F$44, SMALL(IF(ISBLANK($F$3:$F$44)+ISERROR($F$4:$F$44), "", ROW($F$4:$F$44)-MIN(ROW($F$4:$F$44))+1), ROW(1:1)))
    Reply With QuoteRegister To Reply
  2. 09-06-2014, 05:34 PM #2
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: I am stumped on array formulas 

    Please Login or Register  to view this content.

    https://forum.openoffice.org/en/foru...hp?f=9&p=53978
    Reply With QuoteRegister To Reply
  3. 09-06-2014, 06:10 PM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: I am stumped on array formulas

    Try this link...
    http://answers.microsoft.com/en-us/m...d-d4a30116e9a3

    Here is a bunch more mac shortcuts...
    http://www.keyxl.com/aaa6a61/227/Mic...-shortcuts.htm
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  4. 09-06-2014, 07:01 PM #4
    kevin316
    kevin316 is offline
    Registered User
    Join Date
    09-28-2009
    Location
    Alberta Canada
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: I am stumped on array formulas

    I found that post before and tried it all. Just to rule it out I tried it again.

    I included the workbook. The formula is on Available drivers & units E4
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 09-06-2014, 07:07 PM #5
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: I am stumped on array formulas

    another here
    https://exceljet.net/keyboard-shortc...-array-formula
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  6. 09-06-2014, 07:20 PM #6
    kevin316
    kevin316 is offline
    Registered User
    Join Date
    09-28-2009
    Location
    Alberta Canada
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: I am stumped on array formulas

    I seen that one as well what key is the ⌃ key?
    Reply With QuoteRegister To Reply
  7. 09-06-2014, 10:47 PM #7
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Thumbs up Re: I am stumped on array formulas

    Hi
    try this..
    The revised formula..
    =INDEX($F$4:$F$44, SMALL(IF(ISBLANK($F$4:$F$44)+ISERROR($F$4:$F$44), "", ROW($F$4:$F$44)-ROW($F$3)), ROW($A1)))
    check the attached file..
    Attached Files Attached Files
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com
    Excel is not a matter of Experience, its a matter of Application.
    Say Thanks, Click * Add Reputation
    Reply With QuoteRegister To Reply
  8. 09-07-2014, 12:49 AM #8
    kevin316
    kevin316 is offline
    Registered User
    Join Date
    09-28-2009
    Location
    Alberta Canada
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: I am stumped on array formulas

    How did you Get the array function to work or are using a PC?

    That's not working. When a name is selected in "Kaybob" it is removed from the list in Available units & drivers column F. Column E will be will be the same as F with the blank cells removed and the remaining names at the top of the list.
    Reply With QuoteRegister To Reply
  9. 09-07-2014, 01:11 AM #9
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: I am stumped on array formulas

    Yeah... I am using PC
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Can I select an array for a correlation based on a value in a column? STUMPED!
    By buterflyer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-28-2014, 09:13 AM
  2. Stumped on this difficult Array Problem: Anyone willing to see if they can solve
    By tentop6521 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-28-2013, 09:21 PM
  3. [SOLVED] Stumped with Formula Array returning cell adjacent to formula dataset
    By Giles_Silver in forum Excel General
    Replies: 5
    Last Post: 06-04-2012, 12:18 AM
  4. collecting rows into an array for fasten up array formulas, is it possible?
    By naxa in forum Excel General
    Replies: 6
    Last Post: 12-30-2008, 06:52 AM
  5. Stumped on Array
    By Otto Moehrbach in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-13-2005, 12:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1