MMULT Get Column Headings Instead

S

Stephen_IV

Well-known Member
Joined
Mar 17, 2003
Messages
1,180
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Good afternoon,

I have a that works well below. It counts the days that 1 and 6 occur togather. I now need the header row of those days that this occurs, Day 4 and Day 6.

Can someone please help me with this. Thanks in advance Stephen


Book1
ABCDEFGHIJ
1Day 1Day 2Day 3Day 4Day 5Day 6Day 7
211112
32222
43333
5444
655
766666
Sheet1
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Sort by date Sort by votes
Stephen_IV said:
Good afternoon,

I have a that works well below. It counts the days that 1 and 6 occur togather. I now need the header row of those days that this occurs, Day 4 and Day 6.

Can someone please help me with this. Thanks in advance Stephen



******** ******************** ************************************************************************><CENTER><TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" bgColor=#0c266b colSpan=11><TABLE border=0 width="100%" align=center><TBODY><TR><TD align=left>Microsoft Excel - Book1</TD><TD style="FONT-FAMILY: caption; COLOR: #ffffff; FONT-SIZE: 9pt" align=right>___Running: 14.0 : OS = Windows XP </TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px; BORDER-RIGHT: #000000 0.5pt solid" bgColor=#d4d0c8 colSpan=11><TABLE border=0 width="100%" align=center VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-FAMILY: caption; COLOR: #000000; FONT-SIZE: 10pt">(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout</TD><TD vAlign=center align=right><FORM name=formCb755237><INPUT value="Copy Formula" type=button name=btCb873980 *******='window.clipboardData.setData("Text",document.formFb078704.sltNb935705.value);'></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" bgColor=white colSpan=11><TABLE border=0><TBODY><TR><FORM name=formFb078704><TD style="WIDTH: 60px" bgColor=white align=middle><SELECT onchange="document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value" name=sltNb935705><OPTION selected value={=SUM(--(MMULT(TRANSPOSE(--ISNUMBER(MATCH(B2:H7,{1;6},0))),ROW(B2:H7)^0)=2))}>J2</OPTION></SELECT></TD><TD bgColor=#d4d0c8 width="3%" align=right>=</TD><TD bgColor=white align=left><INPUT value={=SUM(--(MMULT(TRANSPOSE(--ISNUMBER(MATCH(B2:H7,{1;6},0))),ROW(B2:H7)^0)=2))} size=80 name=txbFb426622></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" width="2%" align=middle>
</TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>A</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>B</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>C</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>D</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>E</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>F</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>G</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>H</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>I</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>J</CENTER></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" width="2%" align=middle><CENTER>1</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid">Day 1</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid">Day 2</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid">Day 3</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid">Day 4</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid">Day 5</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid">Day 6</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid">Day 7</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" width="2%" align=middle><CENTER>2</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">1</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">1</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">1</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">1</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">2</TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" width="2%" align=middle><CENTER>3</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">2</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">2</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">2</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">2</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" width="2%" align=middle><CENTER>4</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">3</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">3</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">3</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">3</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" width="2%" align=middle><CENTER>5</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">4</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">4</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">4</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" width="2%" align=middle><CENTER>6</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">5</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">5</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" width="2%" align=middle><CENTER>7</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">6</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">6</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">6</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">6</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">6</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-BOTTOM: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; BORDER-TOP: #808080 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" colSpan=11><TABLE width="100%" align=left VALIGN="TOP"><TBODY><TR><TD style="BORDER-BOTTOM: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; WIDTH: 120pt; BORDER-TOP: #808080 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=left>Sheet1</TD><TD></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</CENTER>
Click to expand...
Hi Stephen

J3, control+shift+enter, not just enter, and copy down:
Rich (BB code): 
=IF(ROWS($J$3:J3)<=$J$2,INDEX($B$1:$H$1,
   SMALL(IF(TRANSPOSE(--(MMULT(TRANSPOSE(--ISNUMBER(MATCH($B$2:$H$7,{1;6},0))),
    ROW($B$2:$H$7)^0)=2)),COLUMN($B$1:$H$1)-COLUMN($B$1)+1),ROWS($J$3:J3))),"")
 
Upvote 0
Perfect Aladin! I am always in awe of your talent. Thank you so much again!
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Locked
  • Question Question
month shares same week number vba code
Replies
1
Views
390
Joe4
Joe4
P
  • Question Question
week numbers which share two months, amount of days (vba,userform)
Replies
0
Views
445
PLwolves87
P
B
  • Solved
Looking to expand tool to track vacation pro-rations
Replies
1
Views
307
bh24524
B
A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
1K
AndyEd
A
K
  • Solved
Return Column header for MAX/MIN Value
Replies
3
Views
268
kitm
K

Forum statistics

Threads
1,224,599
Messages
6,179,828
Members
452,946
Latest member
JoseDavid

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top