¥»©«³Ì«á¥Ñ ziv976688 ©ó 2020-12-15 16:34 ½s¿è
Äæ¦ì¼Æ±Æ§ÇÅܤƪº¤½¦¡¬ã²ß-1.rar (2.92 KB)
¤£¦n·N«ä¡AB13ªº¤½¦¡¤@ª½§ï¤£¦¨¡AÀµ½Ð¦U¦ì¤j¤j¤£§[«ü¾É
°ÝÃD¦p¤U~
¨ú"¦¸¼Æ"¦C(B4:AN4)5ӰϬq(8Äæ*4+7Äæ*1=¦@39Äæ)ªº¨CӰϬq³Ì¤j¼Æ~
B6¤½¦¡
=IF((B4=MAX(OFFSET($B4,,INT((COLUMN()-2)/8)*8,,8))),B4,"")
½Ð°Ý¡J
·Q¨ú"¦¸¼Æ"¦C(B11:AN11)5ӰϬq(7Äæ*1+8Äæ*4=¦@39Äæ)ªº¨CӰϬq³Ì¤j¼Æ~
B13ªº¤½¦¡n«ç»ò½s§ï¡H
ÁÂÁÂ |