array formula

[Guest]

Can an array formula access data from a range on a different worksheet?
This one gives me a #VALUE error now I've moved it to a different sheet:

="min - "&(MIN(IF('Sheet 2'!$AA7:$AA5000>0,'Sheet 2'!$AA7:$AA5000)))

Cheers,

 

[Don Guillett]

Did you forget to array enter?

 

[Guest]

ermmmm, no
Because I'd fiddled with it, however, the array braces dissappeared, giving
'#VALUE!' error.
Re-instating the braces gives '#REF!' error
--
Traa Dy Liooar

Jock

Did you forget to array enter?

 

[Gary Keramidas]

the braces aren't entered manually. create your formula and then commit it with
control-shift-enter instead of enter.
--


Gary

ermmmm, no
Because I'd fiddled with it, however, the array braces dissappeared, giving
'#VALUE!' error.
Re-instating the braces gives '#REF!' error

 

[Guest]

Didn't explain myself well there.
Control-shift-enter was used to commit which gave me the '#REF!' error