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

[µo°Ý] ½Ð°Ý¦p¦ó¦Û°Ê¦C¥X¸ê®Æ®w¸ê®Æ

[µo°Ý] ½Ð°Ý¦p¦ó¦Û°Ê¦C¥X¸ê®Æ®w¸ê®Æ

¥»©«³Ì«á¥Ñ urlsyu ©ó 2020-2-10 14:00 ½s¿è

½Ð°Ý¤j¤j¡A°²³]§Ú¦³¸ê®Æ®w¦p¤U
·Q­n±N¨äÂà¸m¦¨³øªí¤º®æ¦¡«áA4¦L¥X¡A¤è«K²{³õ¤H­û®Ö¹ï¶i¥X³f
¨Ò¦p§Ú·Q½Õ¥X¬Y§å¸¹ªº³W®æ0~6

³o»Ý­n¦p¦ó»s§@¡HÁÂÁÂ

¬¡­¶Ã¯1.zip (24.06 KB)

¤j¤j§A¦n¡A§Ú¶K¤W¥H«á¬OªÅ¥ÕÅã¥Ü
§Ú¤§«eª¦¤å¤]¬Oª¾¹D¥ÎOFFSET»yªk
¦ý¥d¦b¦p¦ó§PÂ_¸ê®Æ®w§å¸¹¸ò³W®æ
½Ð°Ý§A´£¨Ñ§PÂ_³W®æ¨Ì¾Ú¬O¦b¨º?

¤j·PÁÂ

TOP

¥»©«³Ì«á¥Ñ urlsyu ©ó 2020-2-10 22:19 ½s¿è

¦^´_ 4# hcm19522
¤j¤j§A¦n
ª¦¤åª¦ªºÀY´ß·w·w
¦¨¥\¤F

¤j¤j¤j·P®¦:L

TOP

¦^´_ 6# hcm19522

½Ð°Ý¤j¤j
¥[¤J¥X³f¸ê®Æ«á¡A·Q»s§@®w¦s¸ê®Æ¡A­n¦p¦ó§PÂ_³W®æÄæ¡H

·P®¦~
¬¡­¶Ã¯1.zip (32.91 KB)

TOP

¦^´_ 8# hcm19522

¦A¦¸·PÁ¤j¤j
³Ì«á·Q±N®w¦s¥u¦C¥X©|¦³®w¦s§å¸¹¦pÀɮשҦC¡A¬ã¨s¦n´X¤Ñ¼g¤£¥X¨Ó:dizzy:
¬¡­¶Ã¯1.zip (33.69 KB)

·P®¦·P®¦

TOP

¦^´_ 10# hcm19522

¤j¤j§A¦n
®w¦sA3 ¤U©Ô{=IFERROR("A000"&SMALL(IF(SUMIF(¸ê®Æ®w!B:B,"A000"&ROW($1:$9)-1,¸ê®Æ®w!$D:$D)-SUMIF(¥X³f!$C:$C,"A000"&ROW($1:$9)-1,¥X³f!$E:$E),ROW($1:$9)-1),ROW(A1)),"")
³o¥y¼gªk¦³­Ó°ÝÃD¡A¸U¤@§Úªº½s¸¹¶W¹L¤Qµ§(¦p¡GA0011)´NµLªk¨Ï¥Î

ÁÂÁ§A

TOP

¦^´_ 12# hcm19522

¤j¤j¦w¦w~
­è­è¸Õ¹L¡A¤£¯à¥¿½TÅã¥Ü
¬¡­¶Ã¯1.zip (33.9 KB)


¤j¤j·P®¦~

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD