hcm19522

=SMALL(IF(MAX((LARGE((MATCH(OFFSET($B$1,LOOKUP(9^9,$AX2:$AX7,ROW(1:6)),,,49),OFFSET($B$1,LOOKUP(9^9,$AX2:$AX7,ROW(1:6)),,,49),)=COLUMN($B:$AX)-1)*OFFSET($B$1,LOOKUP(9^9,$AX2:$AX7,ROW(1:6)),,,49),COLUMN(A1))=OFFSET($B$1,LOOKUP(9^9,$AX2:$AX7,ROW(1:6)),,,49))*(OFFSET($B$1,LOOKUP(9^9,$AX2:$AX7,ROW(1:6)),,,49)/1%%+$B$71:$AX$71))=OFFSET($B$1,LOOKUP(9^9,$AX2:$AX7,ROW(1:6)),,,49)/1%%+$B$71:$AX$71,$B$1:$AX$1),MOD(ROW(A1),7))


OR
BD7:BF7 ¤U©Ô=IFERROR(INDEX($1:$1,AZ7+1),"")

hcm19522

¦^´_ 11# Airman


    «D¤]   (³Ìªñ¬°¦ó¦³3¤H´£¦¹°ÝÃD)
(¤è¦¡¤@)­ì¤½¦¡§ï³Ì«á¬õ¦r³¡¤À  ( COLUMN($B:$AX)-1-->$B$1:$AX$1)

(¤è¦¡¤G)­ì¤½¦¡·í»²§U ,¥¿½Tµ²ªG¦a¤è(BD7:BF7) ,¥t¤U²³æ¤½¦¡   ¤U©Ô

hcm19522

¦^´_ 35# Airman


   °Ñ¦Ò
https://blog.xuite.net/hcm19522/twblog/587392713

hcm19522

AZ7:BB7{=RIGHT(SMALL(IF(MATCH($B7:$AX7,$B7:$AX7,)=COLUMN($B:$AX)-1,$B7:$AX7/1%+$B$1:$AX$1),COLUMN(A1)),2)
½Æ»s¨ì¦U¦æ

hcm19522

¦^´_ 40# Airman

­×¥¿ {=RIGHT(MIN(IF(SMALL(IF(MATCH($B7:$AX7,$B7:$AX7,)=COLUMN($B:$AX)-1,$B7:$AX7),COLUMN(A1))=$B7:$AX7,$B7:$AX7/1%+$B$1:$AX$1)),2)

hcm19522

°Ñ¦Òhttp://forum.twbts.com/viewthrea ... a=pageD1&page=2