Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Definition of an Array Formula (all)

    Can someone give me a good simple definition of what an array formula really is and why you would use one? I've used a couple formulas that had the curly brackets because I was told I needed them, but I'm not quite sure why the curly brackets are needed? How is a formula different if it doesn't have them?

    Thanks in advance for the help.

    -Kelley

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Definition of an Array Formula (all)

    I can't easily answer you. But whilst waiting for a better answer, you might care to do a search on the username BobUmlas and read a few of his utterings within the lounge. Alternatively, pay a quick trip to chip and see if his page helps your understanding.

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Definition of an Array Formula (all)

    Here is Bob Umlas' White Paper. Bob explains by example and he's a master. But I'll be a fool and try for a brief explanation: array formulas permit you to perform metacalculations on groups of related data.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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