If you mean how does one make a formula an array formula: hold down CTRL-SHIFT and then ENTER. If you mean what does the formula do, then this wiki explains the concept: http://www.utteraccess.com/wiki/inde...Array_Formulas.