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

¨Ì¾Ú­­¨î±ø¥ó¦Û°Ê¶ñ¤J§PÂ_

¨Ì¾Ú­­¨î±ø¥ó¦Û°Ê¶ñ¤J§PÂ_

¥»©«³Ì«á¥Ñ jsc0518 ©ó 2019-1-8 22:07 ½s¿è

Dear ¤j¤j,

§Ú·Q¦bexcel  IÄ欰¤¤³]©w§PÂ_¦¡¡A¥¦¬O¨Ì¾ÚCÄ椤ªº¸ê°T(­Ë¼Æ«á­±¨º´X½X)
§PÂ_«á¡A¦bIÄæ¦C¦Û°Ê¶ñ¤W"«ü©w¦r¤¸-¥Õ¦â¡B¶À¦â¡BÂŦâ)¡A­Y³£¤£²Å¦Xªº¸Ü´NªÅ¥Õ


§PÂ_»¡©ú¦p¤U¹Ï
Noname.jpg

TEST.rar (7.38 KB)
Just do it.

¥Î¤F²Âªºªk¤l ¨ä¥Lªº §A»Ý­nªº±ø¥ó §A¥i¥H¸ò§Ú¨º¼Ë ¥h¼W¥[¤U¥h

TEST1.rar (10.89 KB)

TOP

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

TOP

¦^´_ 3# hcm19522
«ôŪ¤Fhcm19522ªº¤èªk¡A¯uªº¨ü¯q¨}¦h¡A·PÁ±z
clio

TOP

¦^´_ 3# hcm19522
hcm19522¤j¤j
¤pªº©î¸Ñ³o­Óµ{¦¡«á¡A¦³¨Ç¦a¤è¤´¤£¬O«Ü¤F¸Ñ¡A¯à§_½Ð±zÀ°§ÚÄÀºÃ©O¡H·PÁ±z
FIND("+"&K$5:K$13,C5)/(K$5:K$13>0)¡A³oÃä¤j¬ùª¾¹D¦bC5¤º¤À§O±N"+" &K5, "+"&K6...¨ì"+"&K13¥N¤J·j´M¬Ý¬O§_¦³²Å¦Xªº¦r¦ê¡A¦ý¬O«á­±¦A/(K$5:K$13>0)ªº¥Î·N¬°¦ó©O¡H
clio

TOP

¦^´_ 3# hcm19522
hcm19522¤j¤j¡A
¥t¥~¦A½Ð±Ð¤@¤U¡A¦p¤U¹Ï¡A§Ú§â¡iFIND("+"&K$5:K$13,C5)¡j³o­Ó¤½¦¡¥t¥~§ì¥X¦b¾ï¦âªº³¡¥÷¡AÆ[¹îµ²ªG¼Æ­È¡A¦ý¬O¥X²{ªº¼Æ­È¡A§Ú¤£¬O«Ü¯à²z¸Ñ¡A
²Ä¤@­Ó12¡A¥i¥Hª¾¹D¦bC5¤¤¦³³Q§ä¨ì+N¡A¦ì¸m¦b12ªº³¡¥÷¡A¦ý¬O¬°¤°»òC6ªºÀ³¸Ó¤]­n§ä¨ì¡A«o¥X²{#VALUE!ªº³¡¥÷¡A­Y¬O»¡¡A¦]¬°¥L¬O¤@­ÓK5:K13ªº°}¦Cµ²ªG¡A¥u·|¬Ý¨ìK5ªº¤ñ¹ïµ²ªG¡A¬°¤°»ò¦bC8ªº¦a¤è¤S¯à§äÅã¥Ü14©O
clio

TOP

¦^´_ 6# clio

FIND("+"&K$5:K$13,C5)§Î¦¨°}¦C ,«D³æ¤@ -->{12;#VALUE!;#VALUE!;#VALUE!;#VALUE!;#VALUE!;#VALUE!;12;12}-->²Ä¤@12¬°K5 ,³Ì«á¤G­Ó12¬°«á­±ªÅ¥ÕÄæ ;©Ò¥H¦A¥[ "/(K$5:K$13>0)" ±Æ°£ªÅ¥ÕÄ檺³]©w -->°t¦XLOOKUP°µ¿ï¾Ü
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 7# hcm19522
·PÁÂhcm19522¡A³o¼Ë³o­Ó§Ú¤F¸Ñ¤F¡A¸U¤À·PÁ±z
clio

TOP

¦^´_ 2# adrian_9832
±z¦n¡A·PÁ±zªº¦^ÂСA§Ú¦³§â§Ú­nªº±ø¥ó¦A·s¼W¤W¥h
TEST OK
THANKS¡I
Just do it.

TOP

¦^´_ 3# hcm19522
·PÁ±zªº¦^ÂмڡA³o¤èªk¤]¤£¿ù¥Î¡A·PÁ¡I:)
Just do it.

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD