Results 1 to 4 of 4

How to get Sub Array

This is a discussion on How to get Sub Array within the Excel Questions forums, part of the Question Forums category; from the array {"aa";"ab";"";"ac";""} I want a sub array with all the items that are not "" (only 3 items) ...

  1. #1
    Board Regular
    Join Date
    Sep 2002
    Location
    tel-aviv, Israel
    Posts
    333

    Default How to get Sub Array

    from the array {"aa";"ab";"";"ac";""} I want a sub array with all the items that are not "" (only 3 items)
    How to do it?

  2. #2
    Board Regular
    Join Date
    Sep 2002
    Location
    tel-aviv, Israel
    Posts
    333

    Default

    Or,
    A1: AA
    A2: AB
    A3:
    A4: AC
    A5
    I want a formula to get an array with the 3 cells with the text

  3. #3
    MrExcel MVP fairwinds's Avatar
    Join Date
    May 2003
    Posts
    8,632

    Default Re: How to get Sub Array

    Hi,

    Try this:

    Formula must be entered with ctrl + shift + enter in B2, then dragged down.

    ******** ******************** ************************************************************************>
    Microsoft Excel - Book2___Running: xl2002 XP : OS = Windows 98
    File Edit View Insert Options Tools Data Window Help About
    =

    A
    B
    C
    D
    1
    2
    AAAA
    3
    ABAB
    4
    AC
    5
    AC
    Sheet5

    [HtmlMaker light Ver1.11] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
    "Fair Winds and Following Seas"

  4. #4
    Board Regular
    Join Date
    Sep 2002
    Location
    tel-aviv, Israel
    Posts
    333

    Default

    it works. thank you. now i'l spend a time to understand it

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com