Thread
:
Matrix to single column
View Single Post
#
13
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg
Posts: n/a
Matrix to single column
For Qty use this formula instead
=INDEX(array1,SUMPRODUCT((array_n=set1 R)*set_r),
SUMPRODUCT((array_n=set1 R)*set_c))
Reply With Quote