Excel Arrays are like Ladies Costumes ;) Array_Week (1 of 4)

We all know there is a feature in Excel called arrays. This is an interesting topic to learn and very challenging either because its an amazing and powerful concept of Excel features. Arrays are like ladies costumes, because it is difficult to understand or to explain to some one about the concept of arrays, similarly the costumes available in the market for ladies. Simple example here is we go for shopping with our girl friend(s) (rarely with wife, right? ;) ) and we really can't expect the budget they spend and the new company brands they choose every time we go. In addition, even companies are also introducing many products to make our ladies look like Angels, right?. In one sentence, Excel Functions create magic with Array features similarly, the ladies create magic with costumes. I agree, do you???

However, let us try to understand the functionality of arrays the way we understand our ladies. ;) Now, let us see few topics about Excel Arrays with repect to Excel Functions.

Array formula performs multiple calculations that on one or more items in an array. Array's will return either single result or multiple results. Array formulas act on two or more sets of values known as array arguments." Arrays works by pushing CTRL +SHIFT + ENTER keys together.

One-Dimensional Array's:

This can be stored in a range that consists of one row or one column.

Two-Dimensional Array's:

This can be stored in a rectangular range of cells that consists of two rows or two columns

RULES TO FOLLOW:

Array formulas cannot be applied to all the cells in the column

Array formulas cannot be handled with more than two arguments

Array formulas works just similar to other formulas but need to use CTRL + SHIFT + ENTER rather just pushing ENTER key

Worksheet with Array formulas cannot be shared to another user when the worksheet is linked to other workbook

DID YOU WORK ON ARRAYS?

Do you work on array formulas in your work. Did you find something challenging while working on arrays. Then, please use this space to share your ideas, feelings, comments, achievements and what not any experiences about this topic in the comment section below.

If you like this post then please do share this post with your friends, relatives, colleagues and of-course with co-hearts to enhance their skills with your help.

If you want to support me for maintaining this blog and to receive latest updates from exceltoxl.com then, please do REGISTER HERE for free. Login details are kept confidential from the public.