¥»©«³Ì«á¥Ñ Airman ©ó 2019-4-16 18:19 ½s¿è
²Ä¤@¦Cªº¹ïÀ³¼Æ.rar (21.04 KB)
AZ7==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,COLUMN($B:$AX)-1),MOD(ROW(A1),7))
°}¦C¤½¦¡ ~~ ¥k©Ô¨ìBB7¦A¤U©Ô¶ñº¡
¥Ø«eAZ7ªº¤½¦¡±ø¥ó¦p¤U~
¥D±ø¥ó=$B7:$AX7ªº«e¤T¤jªº¼Æ¦r(¤¤¦¡±Æ¦W)¡F
¦pªG¥D±ø¥óªº«e¤T¤j¼Æ¦r³£¬°³æ1ӮɡA«h±N¨ä¦b$B1:$AX1ªº¦PÄæ¹ïÀ³¼Æ¦r¨Ì§Ç¶ñ¤JAZ7¡JBB7
°Æ±ø¥ó1=¦pªG¥D±ø¥ó1ªº¨ä¤¤¬Y±Æ¦W¼Æ¡A¦³2Ó(§t)¥H¤W®É¡A«h¿ï¨ú¨ä¦b$B71:$AX71ªº¦PÄæ¹ïÀ³¼Æ¦r¸û¤j¤§±Æ¦WªÌ¡A
¨Ã±N¿ï¨ú«áªº«e¤T¤j¼Æ¦r¤§¦b$B1:$AX1ªº¦PÄæ¹ïÀ³¼Æ¦r¨Ì§Ç¶ñ¤JAZ7¡JBB7
°Æ±ø¥ó2=¦pªG¥D±ø¥ó1ªº¨ä¤¤¬Y±Æ¦W¼Æ¡A¦³2Ó(§t)¥H¤W¡A¥B¨ä¦b$B71:$AX71ªº¦PÄæ¹ïÀ³¼Æ¦r¥ç¬Û¦P®É¡A«h±N¸Ó¬Û¦P±Æ¦WªÌ¥þ¿ï¨ú¡A
¨Ã±N¿ï¨ú«áªº«e¤T¤j¼Æ¦r¤§¦b$B1:$AX1ªº¦PÄæ¹ïÀ³¼Æ¦r¨Ì§Ç¶ñ¤JAZ7¡JBB7
×¥¿ì¦]¡J
·í$B1:$AX1ªº49ӼƦr«D¥Ñ¤p¦Ó¤j±Æ¦C(EX:Sheet1)®É¡A¨ä¤½¦¡ªºµª®×µLªkÀH$B1:$AX1ªº¼Æ¦r±Æ¦CÅÜ°Ê(EX:Sheet2&Sheet3)¦ÓÅܧó¡C
PS¡J³o¬O¤p§Ì¦b¥»½×¾ÂÂ^¨úªº¨ç¼Æ¤½¦¡¡A¦Û¤v¸Õ¤F¤@¤Ñ¡AµLªkÅýAZ7¤½¦¡³£¯à¾A¥Î©óSheet1~ Sheet3¡C
½Ð°Ý¡JÀ³¸Ó¦p¦ó×¥¿AZ7¤½¦¡¡A¥H§Q¤½¦¡³£¯à¾A¥Î©óSheet1~ Sheet3
Àµ½Ð¦U¦ì¥ý¶i´f¤©½ç±Ð!ÁÂÁÂ! |