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