i want to get product of two array (say A(1:10) & B(1:10)) in the
following manner
A1*B10
A2*B9
A3*B8
|
|
|
|
A10*B1

can you please tell me how to do this without using macro? i want to
use only excel functions. i am using MS Excel 2007.

Thanks