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

[µo°Ý] ¦p¦ó¦bªí®æ¤ºÅã¥Ü"¤é"¤Î"¤¤"¦r

[µo°Ý] ¦p¦ó¦bªí®æ¤ºÅã¥Ü"¤é"¤Î"¤¤"¦r

½Ð±Ð­Ó¦ì¤j¤j,¦p¦ó¦b³¯xªí®æ¤ºÅã¥Ü"¤é"¤Î"¤¤"¦r(¦pªþ¥ó)

­È¯Zªí.rar (9.89 KB)

BT8:BT23{=TEXT(MAX(($H$1:$BQ$1=BS8)*($H$2:$BQ$7=$BX$7)*ROW($2:$7))-2,"¤¤;;¤é")

BT8:BT23 ½Æ»s¨ì BW8:BW23
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522
·PÁµL¨p¤À¨É

TOP

¦^´_ 3# hcm19522
¸Ñ1,¤ñ¸û²³æ,¥i¸Ñ¨M§Úªº°ÝÃD,ÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : ¤£­nÀH¤ß©Ò±ý¡A­nÀH¤ß±Ð¨|¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD