Use of array formulas

[Mangolili]

What are some array formulas that prdoduce interesting analysis on excel data?

I am new to array formulas, please let me know if you have any ideas. Thank you.

 

[Aladin Akyurek]

What are some array formulas that prdoduce interesting analysis on excel data?

I am new to array formulas, please let me know if you have any ideas. Thank you.

Well, you could look at posts e.g. at this site saying "constrol+shift+enter" and study the accompanying formulas.

 

[jeffreybrown]

Or http://www.cpearson.com/excel/ArrayFormulas.aspx

 

[Marcelo Branco]

Another

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

M.

 

[Mangolili]

Thank you so much for the replies