I did use that formula, but I do not understand what you mean b
(entered using control shift enter.) When I copy that formula into th
spreadsheet, it gives me a #value error. When I changed the cel
references to the cells I actually am using in my real spreadsheet, i
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 novic
understanding an array, and an array formula. Can you be more specifi
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