ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¨ç¼Æ ½Ð±N10¬q¹ï¨¤¤½¦¡¶i¶¥§ï¬°¤@¦¡¡C

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2020-4-5 18:42 ½s¿è

¦^´_ 2# hcm19522
h¤j¤j : ±z¤Ó¼F®`¤F~
ÁÂÁ±zªº½ç±Ð©MÀ°¦£!·P®¦

TOP

=IF(MAX(OFFSET($B1,INT(COLUMN(E1)/5)*7-(B2>45),INT(COLUMN(E1)/5)*5-5,,5-(B2>45)))=OFFSET($B1,INT(COLUMN(E1)/5)*7-(B2>45),B2-1),B2,"")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD