Array
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Array

  1. #1
    Guest

    Default

     
    What is an array? Is it having 2 formulas in one cell? How does it work?

  2. #2
    . MrExcel's Avatar
    Join Date
    Feb 2002
    Location
    Merritt Island Florida
    Posts
    858
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default

    Introduction here:
    http://www.mrexcel.com/tip011.shtml

    Bill
    View a collection of recent Excel articles in the Excel Daily News

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,767
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default

      
    On 2002-03-15 05:55, Anonymous wrote:
    What is an array? Is it having 2 formulas in one cell? How does it work?
    The term 'array' is often used to refer to a column (e.g., A1:A10)or row range (e.g., A5:D5) housing values.

    In technical Excelese, it refers to an unordered set of values, as in

    {"xza",1,"",7,8,23} [1]

    as opposed to a scalar like: 7.

    Again in Excelese, [1] is also called a constant array.

    Most computations using formulas built with one or more worksheet functions returns a scalar value as would:

    =AVERAGE(A1:A6)

    Many worksheet functions are also capable of returning a set of values (that is, a constant array) as result. When it's appropriate/required to compute a constant array, that intent must be conveyed to Excel's engine by entering the target formula by using the key combination CONTROL+SHIFT+ENTER.

    An array formula performs multiple calculations and then return either a single result (a scalar) or multiple results (a constant array). See 'array' in Excel's Help file.

    There are also functions like SUMPRODUCT or FREQUENCY which, in most cases, do not require entering the formulas built with them by using CONTROL+SHIFT+ENTER.

    You can find many formulas set up for concrete/well-specified problems as array-formulas or SUMPRODUCT formulas in Archives of this board.






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