Please enable JavaScript.

Coggle requires JavaScript to display documents.

MULTI-LAYER-TEMPLATE (各層次 ((3 (對稱 (第一種寫法 (第1欄 (=IF(MOD(ROW(B2)+2,3)=1…

- - - - 對稱
        
        第一種寫法
        
        第1欄
        
        =IF(MOD(ROW(B2)+2,3)=1,VLOOKUP(ROW(B2)-1,D$2:E$1000,2,FALSE),"") #
        
        第2欄
        
        =IF(MOD(ROW(B2)+2,3)=2,VLOOKUP(ROW(B2)-1,D$2:E$1000,2,FALSE),"") #
        
        第3欄
        
        =IF(MOD(ROW(B2)+2,3)=0,VLOOKUP(ROW(B2)-1,D$2:E$1000,2,FALSE),"") #
        
        第二種寫法
        
        第1欄
        
        =IF(MOD(ROW($A2)+3,3)=2,VLOOKUP((QUOTIENT(ROW($A2)+3,3)),$A$2:$B$100,2,FALSE),"") #
        
        第2欄
        
        =IF(MOD(ROW($A2)+3,3)=0,VLOOKUP((QUOTIENT(ROW($A2),3)),$A$2:$B$100,2,FALSE),"") #
        
        第3欄
        
        =IF(MOD(ROW($A2)+3,3)=1,VLOOKUP((QUOTIENT(ROW($A2),3)),$A$2:$B$100,2,FALSE),"") #
      - 不對稱
        
        第一種寫法
        
        第1欄
        
        =IF(MOD(ROW(B2)+2,3)=1,VLOOKUP(ROW(B2)-1,D$2:E$1000,2,FALSE),"")
        
        第2欄
        
        =(IF(MOD(ROW(B3)+2,3)=0,VLOOKUP(ROW(B3)-1,D$2:E$1000,2,FALSE),IF(MOD(ROW(B3)+2,3)=2,VLOOKUP(ROW(B3)-1,D$2:E$1000,2,FALSE),"")))
        
        構成意義IF(MOD(ROW(B3)+2,3)=0,VLOOKUP(ROW(B3)-1,D$2:E$1000,2,FALSE)
        
        3層不對稱
        
        3 more items...
    - - 模仿3層2欄
        
        =IF(MOD(ROW(B2)+11,13)=0,VLOOKUP(ROW(B2)-1,D$2:E$1000,2,FALSE),"")
        
        第2層
        
        =(IF(MOD(ROW(B2)+1,3)=1,VLOOKUP(ROW(B2)-1,D$2:E$1000,2,FALSE),IF(MOD(ROW(B2)+1,3)=2,VLOOKUP(ROW(B2)-1,D$2:E$1000,2,FALSE),""))) # # #
        
        連續相加規則
        
        IF(MOD(ROW(B2)+11,13)=1,VLOOKUP(ROW(B2)-1,D$2:E$1000,2,FALSE),
        
        IF(MOD(ROW(B2)+11,13)=2,VLOOKUP(ROW(B2)-1,D$2:E$1000,2,FALSE),
        
        IF(MOD(ROW(B2)+11,13)=3,VLOOKUP(ROW(B2)-1,D$2:E$1000,2,FALSE),
        
        最後若有12層，結尾就是,""後面加上13個)
        
        最前面要加上=(
        
        目標
        
        在B2，12n+1行都不顯示，因此除數13，餘數為1都不顯示；亦即只顯示餘數為2~0
        
        2 more items...
      - 2欄13層的合併
        
        第1欄
        
        第2欄
        
        (IF(MOD(ROW(B3)+11,13)=1,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=2,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=3,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=4,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=5,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=6,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=7,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=8,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=9,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=10,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=11,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=12,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=2,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=3,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=4,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=5,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=6,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=7,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=8,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=9,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=10,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=11,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),IF(MOD(ROW(B3)+11,13)=12,VLOOKUP(ROW(B3)-2,D$2:F$1000,3,FALSE),))))))))))))))))))))))))