In support of this Thread
https://excelfox.com/forum/showthrea...tiple-Criteria
and answer
https://excelfox.com/forum/showthrea...ll=1#post15046
This is what the transpose of SM_T_D1() looks like ( SM_T_D1() is actually pseudo horizontal rather than vertical , as it is a 1D array )
_____ Workbook: AllFormulasAndVBAMultipleCriteria.xlsm ( Using Excel 2007 32 bit )
Sales Man Territory Dimension John New York Tissue Alfred Washington Soda John New York Soda Alfred New York Tissue Leo Washington Soda Leo New York Tissue Maxwell Washington Towel
Here is the equivalent transpose of array, SM_T_D2()
_____ Workbook: AllFormulasAndVBAMultipleCriteria.xlsm ( Using Excel 2007 32 bit )
Sales Man Territory Dimension John New York Tissue John New York Soda John New York Paper John New York Towel John Washington Tissue John Washington Soda John Washington Paper John Washington Towel Alfred New York Tissue Alfred New York Soda Alfred New York Paper Alfred New York Towel Alfred Washington Tissue Alfred Washington Soda Alfred Washington Paper Alfred Washington Towel Leo New York Tissue Leo New York Soda Leo New York Paper Leo New York Towel Leo Washington Tissue Leo Washington Soda Leo Washington Paper Leo Washington Towel Maxwell New York Tissue Maxwell New York Soda Maxwell New York Paper Maxwell New York Towel Maxwell Washington Tissue Maxwell Washington Soda Maxwell Washington Paper Maxwell Washington Towel
Reply With Quote
Bookmarks