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

[µo°Ý] ´£¨ú¦r¦ê¤º¼Æ¦r¤ñ¤j¤p

[µo°Ý] ´£¨ú¦r¦ê¤º¼Æ¦r¤ñ¤j¤p

·íÂŦâ®Ø¤p©óµ¥©ó390¡A¬õ¦â®Ø¤p©óµ¥©ó90ªº®É­Ô¬°1
·íÂŦâ®Ø¤p©óµ¥©ó390¡A¬õ¦â®Ø¤j©ó90¤p©óµ¥©ó180ªº®É­Ô¬°2

§_«h«h¬°ªÅ¥Õ


ÁÂÁÂ


¡°ÂŦâ®Ø¤º¼Æ¦r¬°3-4¦ì¼Æ¤£µ¥


¦^´_ 1# wayne0303

½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ

¨ú¼Æ¦r.zip (50.98 KB)

TOP

¦^´_ 2# samwang

¥ýÁÂÁ¡I

¦ý¥i¥H¥Î¦¡¤l(¤½¦¡)ªº¤èªk¸Ñ¶Ü¡H

TOP

¦^´_ 3# wayne0303

¤½¦¡¤£¤Ó·|¼g¥u¯à¼g¨ì³o¼Ë¤F¡Aµ{¦¡¤]¦³¤p­×§ï¡A½Ð¦A´ú¸Õ¬Ý¬Ý¡AÁÂÁ¡C

¨ú¼Æ¦r.1.zip (51.86 KB)

TOP

¦^´_ 4# samwang


¦nªº¡I¥ýÁÂÁÂ
§Ú¦A¸Õ¬Ý¬Ý~

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

h¤jªº¤½¦¡¯uªº¦n¼F®`¡A¾Ç°_¨Ó¤F¡A·PÁ¤À¨É¡C

TOP

¥»©«³Ì«á¥Ñ wayne0303 ©ó 2021-6-21 08:32 ½s¿è

¦^´_ 6# hcm19522


«z~·PÁÂh¤j¤jªºÀ°¦£¡I

¦ý³Ì«á­±³o­Ó"0;;"¬O¥Nªí¡H

TOP

¦^´_ 6# hcm19522

R312-1¢X  --- ³oºØªº³Ì«á¤@¸`¦³¥i¯à»~§P!!!...12-1¬O¤é´Á

TOP

¸ê®Æ¤Ó¤Ö, µLªk¦hÅçÃÒ:
=CHOOSE((-LOOKUP(,-RIGHT(TEXT(,"[$"&B2&"]"),{1,2,3,4}))<=390)*SUM(N(-LOOKUP(1,-RIGHT(LEFT(B2,LEN(B2)-1),{1,2,3,4}))<={90,180}))+1,"",2,1)

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤H¤£©È¿ù¡A´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD