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

Thread: CSE Formulae

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Chester, England
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm new to Mr Excel but I've just tried out the CSE formulae (array formulae). Very impressed, but two questions:
    1 - Is there a maximum size of array that Excel will handle?
    2 - Is it possible to use an array across a range of worksheets?

    Any help gratefully received.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    1. The physical limits of the worksheet, but some functions that handle arrays have their own limits (consult Help).
    2. No.

    [ This Message was edited by: Mark W. on 2002-03-06 11:11 ]

  3. #3
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi JC3

    Be careful with array formulas they can be a trap that renders your Workbook virtually unusable! They slooowww down Excels re-calculation to a crawl if you have too many. Have a look at the Excel help of the "Database functions" these are far superior and are desinged to do what most unwary users use array formulas for.

    They most certainly do have some contraints which I list here:
    http://www.ozgrid.com/Excel/Arrays.htm



  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    JC3, array formulae are quite powerful and useful. I'm glad to see that you're taking the time to understand them.

Some videos you may like

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
  •