Hi
copy this formula in your formula bar but instead of hitting ENTER in
your formula bar to finish the formula entry hit CTRL+SHIFT+ENTER
together.

See
http://www.cpearson.com/excel/array.htm
for more information about array formulas


--
Regards
Frank Kabel
Frankfurt, Germany


I did use that formula, but I do not understand what you mean by
(entered using control shift enter.) When I copy that formula into
the
spreadsheet, it gives me a #value error. When I changed the cell
references to the cells I actually am using in my real spreadsheet,
it
gives me this error. And when I press the control, shift and enter
key, nothing happens. I am not a novice using Excel, but I am a
novice
understanding an array, and an array formula. Can you be more
specific
with your instructions??? If not, I do appreciate what you did tell
me. And thank you Frank from Germany.


---
Message posted from http://www.ExcelForum.com/