using formula in A2 =average(IT:Index(A1:IT1,sumproduct(large(column(A :IT)*
(A1:IT1<""),A4))))
A4 is variable cell for calculation. However, I require result to be in row
1. Keep getting curcular ref. Require result in a3
/
Can anyone assist?
brian(at )thompson3001.fsnet.co.uk
Regards
Brian
--
Message posted via
http://www.officekb.com