¤j®a¦n¡A
·Q½Ð±Ð¤j®a¤@Ó·Q¤F«Ü¤[ªº°ÝÃD¡G
»¡©ú¡G
(1) ÄæA¡G½s¸¹¡BÄæB¡Gµù
(2) ÄæE¡G¬O§Ú¥Ø«e¤wª¾ªº¤½¦¡¡u=IFERROR(TEXT(SMALL(IF(A$2:A$99="","",VALUE(A$2:A$99)),ROW(A1)),"000"),"")¡v
(3) ÄæH¬O¹w´Á·Q§e²{ªºµ²ªG¡G±NÄæAªº¼Æ¦r¥Ñ¤p¨ì¤j±Æ§Ç¡A¦ýn±Æ°£ÄæB¦³¼Ðµù¡uX¡vªº¼Æ¦r«á§e²{ªºµ²ªG¡C
=> ÄæE¬O¦C¥X©Ò¦³ªº¼Æ¦r¥Ñ¤p¨ì¤j¡A¦ý¦pªG·Qn±Æ°£ÄæB¦³¼Ðµù¡uX¡vªº¼Æ¦r¡A¨ºÄæEªº¤½¦¡À³¸Ón¦p¦óקï©O?
ªþ¤WªþÀÉ¡G
¬¡¶Ã¯1.zip (8.06 KB)
¦A³Â·Ð¦U¦ì¤j¤j¨ó§U¡A«D±`·PÁ¤j®a¡C |