-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of attapan_chainarongb...@ck-mail.com
Sent: 08 September 2012 6:49
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ MMULT functions questions
One more question
1. If in table one Product
-mail.com
Sent: 10 September 2012 8:51
To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ MMULT functions questions
Dear Rajan
Thanks for your idea, If I've have many row (data) ,So it still work ?
Attapan.
From: excel-macros
[mailto:excel-macros@googlegroups.com]
On Behalf Of attapan_chainarongb...@ck-mail.com
Sent: 08 September 2012 6:49
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ MMULT functions questions
One more question
1. If in table one Product No. not sory by (A,B,C) but it alternate
-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ MMULT functions questions
One more question
1. If in table one Product No. not sory by (A,B,C) but it alternate (Example
C,A,B or A,C,B)
(See green hightlight)
2. How can I get it on table 4 ?
From: excel-macros@googlegroups.commailto:excel
Use this as array
=MMULT(OFFSET(INDEX($A$3:$A$5,MATCH(A23,$A$3:$A$5,0),1),,1,1,4),$B$9:$F$12)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of attapan_chainarongb...@ck-mail.com
Sent: 07 September
, 2012 9:30 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ MMULT functions questions
Use this as array
=MMULT(OFFSET(INDEX($A$3:$A$5,MATCH(A23,$A$3:$A$5,0),1),,1,1,4),$B$9:$F$12)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.commailto:excel