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:$AA50000,'Sheet 2'!$AA7:$AA5000)))

Cheers,
--
Traa Dy Liooar

Jock