Enter an array formula
When you enter an array formula, Microsoft Excel automatically inserts
the formula between { } (braces).

If the array formula will return one result, click the cell in which
you want to enter the array formula.
If the array formula will return multiple results, select the range of
cells in which you want to enter the array formula.

Type the array formula.


Press CTRL+SHIFT+ENTER.

When editing the formula you will need to also Press CTRL+SHIFT+ENTER
to maintain it as an array formula.


--
DCSwearingen


------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=399629