Array formula returning wrong results

[TUNGANA KURMA RAJU]

One of my arrray formula giving me two fifferent results.In one case it is
giving correct result and the same formula in other case(I didn't modified
the range) giving me wrong results.I did verified by clicking' fx' edit
formula button in formula bar and verified the formula result,surprisingly
the formula result in that formula edit widow showing correct result.I am
puzzled and helpless.Everytime after entering array formula I used
cntrl+shift+enter buttons.

[Bob Phillips]

Show the formulae and data?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TUNGANA KURMA RAJU" <TUNGANAKURMARAJU@discussions.microsoft.com> wrote in
message news:2C013286-D126-4BDF-8059-3045206937E1@microsoft.com...
> One of my arrray formula giving me two fifferent results.In one case it is
> giving correct result and the same formula in other case(I didn't
modified
> the range) giving me wrong results.I did verified by clicking' fx' edit
> formula button in formula bar and verified the formula result,surprisingly
> the formula result in that formula edit widow showing correct result.I am
> puzzled and helpless.Everytime after entering array formula I used
> cntrl+shift+enter buttons.