Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Array
Can someone please explain to me how to make an array and what it is used
for, I have not been able to understand this concept when using excel. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Array
Do you mean like an array formula?
Check Bob Phillips' site: http://www.xldynamic.com/source/xld.SUMPRODUCT.html And Chip Pearson's: http://cpearson.com/excel/ArrayFormulas.aspx And a white paper by Bob Umlas: http://www.emailoffice.com/excel/arrays-bobumlas.html Jack wrote: Can someone please explain to me how to make an array and what it is used for, I have not been able to understand this concept when using excel. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Array
Jack --
An array is simply a table of information. There are much more technical approaches, but that's it in a nutshell. Excel has lots of formulas designed to extract information from tables of information -- lookup formulas, index/match, sumproduct, and many more. It also has a tool called an 'array formula', which is also called 'CSE' because you press ctrl-shift-enter. Suppose you had two columns of data and wanted to find the lowest ratio between the different row entries. You would use a CSE formula to compute that, something like =MIN(A1:A10/B1:B10), entered by pressing Ctrl-Shift-Enter at the same time. Try it. HTH "Jack" wrote: Can someone please explain to me how to make an array and what it is used for, I have not been able to understand this concept when using excel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate an array that is a subset of a larger array? | Excel Worksheet Functions | |||
Array: Counting multiple values within array | Excel Worksheet Functions | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
Goal Seek On Members of an Array within Array | Excel Worksheet Functions |