"JE McGimpsey" wrote in message
...
Your #NUM! error comes from the fact that you can't use entire columns
(or rows) in array formulae

Are you sure? Array fomulas for whole rows seem to work for me.

--
Regards

Sandy

Replace@mailinator with @tiscali.co.uk


"