how to learn Array Formulas...

Hello All,

I am very happy for to be part of this forum. Really i am learning so many new things here such as getting clarifications or clarifying others doubts..this is really very good platform..

Here is my question.

As i observed so many soluations are based on the array formulas. its a bit hard to understand the arrary formulas.so, can anyone suggest some study material for array formulas..how to learn step by step...

Thanks in advance to all..

Kind Regards,
Vishnu V

Hi Vishnu,

I would suggest you to watch a video tutorial - may be uTube videos on Excel Array formulas... thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Here is a learning link from microsoft :0

http://office.microsoft.com/en-us/ex...001087290.aspx

Regards,
DILIPandey

<click on below 'star' if this helps>

You are welcome Vishnu..

Suggest you to mark this thread as [SOLVED]. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

I think this site is also a good one.
http://www.cpearson.com/excel/ArrayFormulas.aspx

These also help understand the topic
http://www.databison.com/index.php/e...ray-constants/
http://www.ozgrid.com/Excel/arrays.htm
http://www.exceluser.com/explore/arrays1.htm

or try:

Array Formulas

Hi dilipandy,

I'd suggest you add a link to your favorite YouTube video with this answer. I found this answer lacking. It would be like telling an OP to google the internet for "Excel Array", not much help.

One step better than dili?