Compare multiple columns and list common values in separate column

Preacherman771

New Member
Joined
Jun 15, 2021
Messages
46
Office Version
  1. 365
Platform
  1. Windows
I have a table which contains the weekly opponent for the header team. (BU34:BX51). I want to in column BY34:BY51 list all of the common teams.

Cell Formulas
RangeFormula
BU32BU32=IF(W32="@",X32&"@",IFERROR(INDEX(X32:X35,SMALL(IF(X32:X35<>"",ROW(X32:X35)-ROW(INDEX(X32:X35,1,1))+1),1)),""))
BV32BV32=IF(W33="@",X33&"@",IFERROR(INDEX(X32:X35,SMALL(IF(X32:X35<>"",ROW(X32:X35)-ROW(INDEX(X32:X35,1,1))+1),2)),""))
BW32BW32=IF(W34="@",X34&"@",IFERROR(INDEX(X32:X35,SMALL(IF(X32:X35<>"",ROW(X32:X35)-ROW(INDEX(X32:X35,1,1))+1),3)),""))
BX32BX32=IF(W35="@",X35&"@",IFERROR(INDEX(X32:X35,SMALL(IF(X32:X35<>"",ROW(X32:X35)-ROW(INDEX(X32:X35,1,1))+1),4)),""))
BT34BT34=Data!CU$6
BU34:BX34BU34=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT34=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT34=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT34=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT34=SchedData[Wk'#]),0))),"")))
BT35BT35=Data!CU$7
BU35:BX35BU35=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT35=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT35=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT35=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT35=SchedData[Wk'#]),0))),"")))
BT36BT36=Data!CU$8
BU36:BX36BU36=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT36=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT36=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT36=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT36=SchedData[Wk'#]),0))),"")))
BT37BT37=Data!CU$9
BU37:BX37BU37=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT37=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT37=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT37=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT37=SchedData[Wk'#]),0))),"")))
BT38BT38=Data!CU$10
BU38:BX38BU38=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT38=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT38=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT38=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT38=SchedData[Wk'#]),0))),"")))
BT39BT39=Data!CU$11
BU39:BX39BU39=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT39=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT39=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT39=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT39=SchedData[Wk'#]),0))),"")))
BT40BT40=Data!CU$12
BU40:BX40BU40=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT40=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT40=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT40=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT40=SchedData[Wk'#]),0))),"")))
BT41BT41=Data!CU$13
BU41:BX41BU41=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT41=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT41=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT41=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT41=SchedData[Wk'#]),0))),"")))
BT42BT42=Data!CU$14
BU42:BX42BU42=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT42=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT42=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT42=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT42=SchedData[Wk'#]),0))),"")))
BT43BT43=Data!CU$15
BU43:BX43BU43=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT43=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT43=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT43=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT43=SchedData[Wk'#]),0))),"")))
BT44BT44=Data!CU$16
BU44:BX44BU44=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT44=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT44=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT44=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT44=SchedData[Wk'#]),0))),"")))
BT45BT45=Data!CU$17
BU45:BX45BU45=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT45=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT45=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT45=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT45=SchedData[Wk'#]),0))),"")))
BT46BT46=Data!CU$18
BU46:BX46BU46=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT46=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT46=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT46=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT46=SchedData[Wk'#]),0))),"")))
BT47BT47=Data!CU$19
BU47:BX47BU47=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT47=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT47=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT47=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT47=SchedData[Wk'#]),0))),"")))
BT48BT48=Data!CU$20
BU48:BX48BU48=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT48=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT48=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT48=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT48=SchedData[Wk'#]),0))),"")))
BT49BT49=Data!CU$21
BU49:BX49BU49=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT49=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT49=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT49=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT49=SchedData[Wk'#]),0))),"")))
BT50BT50=Data!CU$22
BU50:BX50BU50=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT50=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT50=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT50=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT50=SchedData[Wk'#]),0))),"")))
BT51BT51=Data!CU$23
BU51:BX51BU51=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT51=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT51=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT51=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT51=SchedData[Wk'#]),0))),"")))
Press CTRL+SHIFT+ENTER to enter array formulas.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
What exactly do you mean by "list all of the common teams"?
 
Upvote 0
Between the four columns there are various opponents that the header team plays which the other three may also play. e.g., all four teams will eventually play "LV", "WAS", but only one plays "CIN" (BU42), so it would not appear in the list. I tried using the formula =IF(COUNTIF(BU$34:BX$51,BU34)>1,BU34,"") and dragging it from BY34 down to BY51. It came pretty close, except since "BUF" does not play itself, it did not list "BUF" which the other 3 teams do play. Similarly, if I would have included BV34,BW34,BX34 in the search values, it would give the same list with the exception of the header team not being listed since it does not play itself. Since each one of those four teams, BUF, MIA, NE, and NYJ play each other twice, I would like somehow in the final list all four listed twice each along with the other common teams.

There is one more catch, but I believe once the basic formula is given, I can then adapted it accordingly. The catch is that what I am creating is one step of determining how to break a tie record between, in this case, these four teams. Since I am creating it to stand alone, there may be times that the resulting scenario may be that 3 teams are tied or 2 or 4. Depending on the number, the ones that are tied will appear as the header teams across Bu32:BU34.

Cell Formulas
RangeFormula
BU32BU32=IF(W32="@",X32&"@",IFERROR(INDEX(X32:X35,SMALL(IF(X32:X35<>"",ROW(X32:X35)-ROW(INDEX(X32:X35,1,1))+1),1)),""))
BV32BV32=IF(W33="@",X33&"@",IFERROR(INDEX(X32:X35,SMALL(IF(X32:X35<>"",ROW(X32:X35)-ROW(INDEX(X32:X35,1,1))+1),2)),""))
BW32BW32=IF(W34="@",X34&"@",IFERROR(INDEX(X32:X35,SMALL(IF(X32:X35<>"",ROW(X32:X35)-ROW(INDEX(X32:X35,1,1))+1),3)),""))
BX32BX32=IF(W35="@",X35&"@",IFERROR(INDEX(X32:X35,SMALL(IF(X32:X35<>"",ROW(X32:X35)-ROW(INDEX(X32:X35,1,1))+1),4)),""))
BT34BT34=Data!CU$6
BU34:BX34BU34=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT34=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT34=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT34=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT34=SchedData[Wk'#]),0))),"")))
BY34:BY51BY34=IF(COUNTIF(BU$34:BX$51,BU34)>1,BU34,"")
BT35BT35=Data!CU$7
BU35:BX35BU35=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT35=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT35=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT35=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT35=SchedData[Wk'#]),0))),"")))
BT36BT36=Data!CU$8
BU36:BX36BU36=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT36=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT36=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT36=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT36=SchedData[Wk'#]),0))),"")))
BT37BT37=Data!CU$9
BU37:BX37BU37=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT37=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT37=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT37=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT37=SchedData[Wk'#]),0))),"")))
BT38BT38=Data!CU$10
BU38:BX38BU38=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT38=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT38=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT38=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT38=SchedData[Wk'#]),0))),"")))
BT39BT39=Data!CU$11
BU39:BX39BU39=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT39=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT39=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT39=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT39=SchedData[Wk'#]),0))),"")))
BT40BT40=Data!CU$12
BU40:BX40BU40=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT40=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT40=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT40=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT40=SchedData[Wk'#]),0))),"")))
BT41BT41=Data!CU$13
BU41:BX41BU41=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT41=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT41=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT41=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT41=SchedData[Wk'#]),0))),"")))
BT42BT42=Data!CU$14
BU42:BX42BU42=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT42=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT42=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT42=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT42=SchedData[Wk'#]),0))),"")))
BT43BT43=Data!CU$15
BU43:BX43BU43=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT43=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT43=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT43=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT43=SchedData[Wk'#]),0))),"")))
BT44BT44=Data!CU$16
BU44:BX44BU44=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT44=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT44=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT44=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT44=SchedData[Wk'#]),0))),"")))
BT45BT45=Data!CU$17
BU45:BX45BU45=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT45=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT45=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT45=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT45=SchedData[Wk'#]),0))),"")))
BT46BT46=Data!CU$18
BU46:BX46BU46=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT46=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT46=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT46=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT46=SchedData[Wk'#]),0))),"")))
BT47BT47=Data!CU$19
BU47:BX47BU47=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT47=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT47=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT47=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT47=SchedData[Wk'#]),0))),"")))
BT48BT48=Data!CU$20
BU48:BX48BU48=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT48=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT48=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT48=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT48=SchedData[Wk'#]),0))),"")))
BT49BT49=Data!CU$21
BU49:BX49BU49=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT49=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT49=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT49=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT49=SchedData[Wk'#]),0))),"")))
BT50BT50=Data!CU$22
BU50:BX50BU50=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT50=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT50=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT50=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT50=SchedData[Wk'#]),0))),"")))
BT51BT51=Data!CU$23
BU51:BX51BU51=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT51=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT51=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT51=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT51=SchedData[Wk'#]),0))),"")))
Press CTRL+SHIFT+ENTER to enter array formulas.
 
Upvote 0
Maybe
Excel Formula:
=FILTER(BU32:BU51,COUNTIFS(BU32:BX51,BU32:BU51)>3)
 
Upvote 0
Thanks for the suggestion. When I so as not make a typing error, copied and pasted it in BY34 it returned BUF. However, when I clicked and dragged it down to BY51, it returned BUF in each cell in the column. Any further suggestions?
 
Upvote 0
Do not drag it down, just put it in BY51 & normally enter it, do not use Ctrl Shift Enter.
 
Upvote 0
That did it! Thanks, looks great. MIA, NE, NYJ are listed twice along with all of the common opponents. However, BUF got listed only once. As I shared before, it needs to be listed as each of the other three teams play them twice. Any suggestions on how to possibly fine tune it. When I entered the formula in BY51, without hitting ctr - shift it returned spill. Initially I left it blank but then I went ahead and copied the formula only this time hitting ctrl - shift. It returned BUF. As I shared, this table is one that I am creating to stand alone and updates automatically. I manually changed the 4 header teams, and column BY updated just fine listing the one new BU header team in BY34 and then again in BY51. So if you, or someone else reading this link, do not know how to fine tune the formula, maybe this would be one way that it could.

Cell Formulas
RangeFormula
BU32BU32=IF(W32="@",X32&"@",IFERROR(INDEX(X32:X35,SMALL(IF(X32:X35<>"",ROW(X32:X35)-ROW(INDEX(X32:X35,1,1))+1),1)),""))
BV32BV32=IF(W33="@",X33&"@",IFERROR(INDEX(X32:X35,SMALL(IF(X32:X35<>"",ROW(X32:X35)-ROW(INDEX(X32:X35,1,1))+1),2)),""))
BW32BW32=IF(W34="@",X34&"@",IFERROR(INDEX(X32:X35,SMALL(IF(X32:X35<>"",ROW(X32:X35)-ROW(INDEX(X32:X35,1,1))+1),3)),""))
BX32BX32=IF(W35="@",X35&"@",IFERROR(INDEX(X32:X35,SMALL(IF(X32:X35<>"",ROW(X32:X35)-ROW(INDEX(X32:X35,1,1))+1),4)),""))
BT34BT34=Data!CU$8
BU34:BX34BU34=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT34=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT34=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT34=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT34=SchedData[Wk'#]),0))),"")))
BY34:BY49BY34=FILTER(BU32:BU51,COUNTIFS(BU32:BX51,BU32:BU51)>3)
BT35BT35=Data!CU$9
BU35:BX35BU35=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT35=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT35=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT35=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT35=SchedData[Wk'#]),0))),"")))
BT36BT36=Data!CU$10
BU36:BX36BU36=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT36=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT36=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT36=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT36=SchedData[Wk'#]),0))),"")))
BT37BT37=Data!CU$11
BU37:BX37BU37=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT37=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT37=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT37=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT37=SchedData[Wk'#]),0))),"")))
BT38BT38=Data!CU$12
BU38:BX38BU38=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT38=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT38=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT38=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT38=SchedData[Wk'#]),0))),"")))
BT39BT39=Data!CU$13
BU39:BX39BU39=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT39=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT39=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT39=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT39=SchedData[Wk'#]),0))),"")))
BT40BT40=Data!CU$14
BU40:BX40BU40=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT40=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT40=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT40=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT40=SchedData[Wk'#]),0))),"")))
BT41BT41=Data!CU$15
BU41:BX41BU41=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT41=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT41=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT41=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT41=SchedData[Wk'#]),0))),"")))
BT42BT42=Data!CU$16
BU42:BX42BU42=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT42=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT42=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT42=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT42=SchedData[Wk'#]),0))),"")))
BT43BT43=Data!CU$17
BU43:BX43BU43=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT43=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT43=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT43=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT43=SchedData[Wk'#]),0))),"")))
BT44BT44=Data!CU$18
BU44:BX44BU44=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT44=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT44=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT44=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT44=SchedData[Wk'#]),0))),"")))
BT45BT45=Data!CU$19
BU45:BX45BU45=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT45=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT45=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT45=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT45=SchedData[Wk'#]),0))),"")))
BT46BT46=Data!CU$20
BU46:BX46BU46=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT46=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT46=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT46=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT46=SchedData[Wk'#]),0))),"")))
BT47BT47=Data!CU$21
BU47:BX47BU47=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT47=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT47=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT47=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT47=SchedData[Wk'#]),0))),"")))
BT48BT48=Data!CU$22
BU48:BX48BU48=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT48=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT48=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT48=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT48=SchedData[Wk'#]),0))),"")))
BT49BT49=Data!CU$23
BU49:BX49BU49=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT49=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT49=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT49=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT49=SchedData[Wk'#]),0))),"")))
BT50BT50=Data!CU$24
BU50:BX50BU50=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT50=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT50=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT50=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT50=SchedData[Wk'#]),0))),"")))
BT51BT51=Data!CU$25
BU51:BX51BU51=IF(BU32="","", IF(RIGHT(BU32,1)<>"@",IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(BU32=SchedData[Away])*($BT51=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(BU32=SchedData[Home])*($BT51=SchedData[Wk'#]),0))),""), IFERROR(IFERROR(INDEX(SchedData[Home],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Away])*($BT51=SchedData[Wk'#]),0)),INDEX(SchedData[Away],MATCH(1,(TEXTBEFORE(BU32,"@")=SchedData[Home])*($BT51=SchedData[Wk'#]),0))),"")))
BY51BY51=FILTER(BU32:BU51,COUNTIFS(BU32:BX51,BU32:BU51)>3)
Press CTRL+SHIFT+ENTER to enter array formulas.
Dynamic array formulas.
 
Upvote 0
How about
Excel Formula:
=LET(f,FILTER(BU32:BU51,COUNTIFS(BU32:BX51,BU32:BU51)>3),VSTACK(BU32,FILTER(f,f<>"")))
 
Upvote 0
Solution
You're welcome & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,223,884
Messages
6,175,174
Members
452,615
Latest member
bogeys2birdies

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