Array Formulas

  • Thread starter Thread starter mkaake
  • Start date Start date
M

mkaake

After working for a long time with Excel, visiting these forums man
times, and creating some monster worksheets of my own, there's on
thing that I've never really been able to pick up on, and I was hopin
you all could help me figure it out.

What exactally is an array formula, and why would someone use i
instead of a 'regular' formula?

Never quite made sense to me.

Anyhew, thanks for the time...

mat
 
Matt,

Array formulas basically evaluate the same formula multiple times, indexing
the cells each time. A single array formula can take the place of an entire
column of regular formulas. For a better explanation, start here:

http://www.cpearson.com/excel/array.htm

HTH,
Bernie
MS Excel MVP
 
This might help:

http://www.cpearson.com/excel/array.htm
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

After working for a long time with Excel, visiting these forums many
times, and creating some monster worksheets of my own, there's one
thing that I've never really been able to pick up on, and I was hoping
you all could help me figure it out.

What exactally is an array formula, and why would someone use it
instead of a 'regular' formula?

Never quite made sense to me.

Anyhew, thanks for the time...

matt
 
Back
Top