How to get Sub Array

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: How to get Sub Array

  1. #1
    Board Regular
    Join Date
    Sep 2002
    Location
    tel-aviv, Israel
    Posts
    335
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    335
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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,637
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    335
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

User Tag List

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