Home Page Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word Host your Web site with PureHost! |
Sunday, November 23, 2008 – Permalink – Array FormulasGood orderly directionAn array is defined as "An orderly arrangement". It can be thought of as a collection of data packaged in a container. The individual items in the container can be selected by referring to their location; first, second, and so on.
"Have you ever sat in front of your monitor pulling your hair out trying to identify duplicate entries in a list? If so, you should learn about Microsoft Excel's array formulas. In fact, you can use array formulas to perform calculations that are otherwise impossible in Excel, and you can enhance the power of some of the program's existing functions." Excel's Array Formulas By Helen Bradley Chip Pearson: Introduction To Array Formulas "Array Formulas are formulas that work with arrays, instead of individual numbers, as arguments to the functions that make up the formula"
Labels: Excel <Doug Klippert@ 3:27 AM |