I tried it both ways - same results.
"Max" wrote:
"Mary-Lou" wrote:
Thanks. When I enter the array forumula, the cell value displays zero
(which is incorrect). But when I edit the function, the 'formula results"
displays 163 (which is correct). Why wouldn't the 163 display in the cell?
Don't remember saying it is an array formula, requiring CSE <g.
Just press normal ENTER to confirm the formula,
after pasting/placing it within the formula bar
(just correct the inadvertent line breaks in the formula
when you copy paste it direct from the post)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---