Matrix to single column
You are a wizard Herbert. Thanks very much that does it. I'd like to find out
where a person learns about these things. Especially "array_n=set1 R".
Thanks again,
RDW
"Herbert Seidenberg" wrote:
For Qty use this formula instead
=INDEX(array1,SUMPRODUCT((array_n=set1 R)*set_r),
SUMPRODUCT((array_n=set1 R)*set_c))
|