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

[µo°Ý] ´¡¤J¤@­Ó©Î¦h­Ó¦C®É¯à¦Û°Ê¶ñ¥R¥N¤J¤½¦¡

[µo°Ý] ´¡¤J¤@­Ó©Î¦h­Ó¦C®É¯à¦Û°Ê¶ñ¥R¥N¤J¤½¦¡

1.A2¥HVBA¿é¤J¥N½X=IF(B2="","",SUBTOTAL(103,$B$2:B2))
2.H2¥HVBA¿é¤J¥N½X=IF(E2="","",MID(E2,FIND("-",E2)+1,4))
3.BÄæ(B2)³¡ªù¿é¤J«áIJ°Ê¨Æ¥ó¦Û°Ê±a¤JA2¤ÎH2¤½¦¡
4.B3¿é¤J¬ÛÃö³¡ªù«áA3¤ÎH3¦Û°Ê¶ñ¥R¥N¤J¤½¦¡...¥H¦¹Ãþ±À
5.´¡¤J¤@­Ó©Î¦h­Ó¦C®É¯à¦Û°Ê¶ñ¥R¥N¤J¤½¦¡
6.§t¦³¤½¦¡Àx¦s®æ§Æ±æ¯àÁôÂÃ



1130505.rar (11.71 KB)

6.§t¦³¤½¦¡Àx¦s®æ§Æ±æ¯àÁôÂÃ???
ÁôÂ佦¡ ©Î ÁôÂÃÄæ¦ì???
¶·«OÅ@¤u§@ªí¤~¯à¿ì¨ì//

¬JµM­nchange¨Æ¥óIJµo, ¥iª½¥Xµ²ªG¤£¯d¤½¦¡

TOP

¦^´_ 2# ­ã´£³¡ªL


·PÁ±zªº¦^ÂÐ
1.»Ý«OÅ@¤u§@ªí¡I(¨Ã¯à´¡¤J¤@­Ó©Î¦h­Ó¤u§@¦C½s¿è)
2.ª½¥Xµ²ªG

TOP

¤µ¤Ñ¦³ÂIªÅ, °µ¤@¤U//
1) ªí®æ¥Î©w¸q¦WºÙ°µ¥|½ü©w¦ì, ¤è«K¥Îµ{¦¡¤Þ¥Î//
2) ³o¥u¬O½d¨Ò, ¦Û¤v­×§ïÀ³¥Î
Xl0000238v01.rar (16.68 KB)

TOP

¦^´_ 4# ­ã´£³¡ªL

·PÁ±zªº¦^ÂР  ^^

°w¹ï©Ò­z°ÝÃD¥¼¸Ô¥[»¡©ú...
©Ò»Ý¥Î³~¬O¦]½s¸¹³¡ªù¦³§O¼vÅT...
­Yµ§¼Æ¦hµ§®É¤@®ÉµLªk¹îı½s¸¹¦Ü´X¸¹???
·sÁʪ««~«ØÀɮɧƱæ¦b©Ò»Ý³¡ªù¥½µ§·s¼W½s¸¹
¤ñ¸û¦n±N½s¸¹³sÄò¤@­P(¦¹®É¦b¥½µ§¦C¥kÁä´¡¤J©Ò»Ý?ªÅ¥Õ¦C)




Xl0000238v01+.rar (14.12 KB)

TOP

µo©««e´N­n³W¹º¤Î³]­p¦n§¹¾ãªí®æ, ¨Ã»¡©ú»Ý¨D¬yµ{,
§K±o¤§«e¼gªº³£­n¥´±¼­«¼g, ®ö¶O¤j®a®É¶¡~~
Xl0000238v02.rar (17.93 KB)

TOP

¦^´_ 6# ­ã´£³¡ªL

·PÁª©¥D¼ö¤ßªº¦^ÂР  ^^

»¡©ú»Ý¨D¬yµ{¥¼¸Ô¥[±Ô­z³y¦¨§xÂZ­P·N

ª©¥D¥H¦@¥Î°Ñ·Ó³]¸m¤FÀx¦s®æªº®æ¦¡¡þÅçÃÒ²M³æ¡þ¤½¦¡¡K¥H¸ê°Ñ¦Ò

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD