What is Array Formula

[sanjeev kumar]

I am very confused about the use of an Array Formula. What is it actually and where it is used? Plz tell anyone in simple to advance way.

 

[Somendra Misra]

Hi Sanjeev,

Please go through the below links to have in-depth knowledge about the topic:

http://office.microsoft.com/en-in/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx

http://chandoo.org/wp/2009/03/25/using-array-formulas-example1/

http://www.cpearson.com/excel/arrayformulas.aspx

http://www.ozgrid.com/Excel/arrays.htm


http://www.mrexcel.com/articles/CSE-array-formulas-excel.php


Regards,

 

[Colin Legg]

Here's another one which I wrote many years ago....

http://www.xtremevbtalk.com/showthread.php?t=296012

 

[ashish mehra]

Extremely helpful links.

Thanks SM & Colin.

Regards,
AM