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

¦C¥X¸ê®Æ©Ò¦bªº¦æ¼Æ?

¦C¥X¸ê®Æ©Ò¦bªº¦æ¼Æ?



¤j®a¦n¡A·Q½Ð°Ý¦p¦ó§ä¥X¸ê®Æ©Ò¦bªº¦æ¼Æ©O?
¦p¹Ï¡G
(1) AºØÃþ¬O¦b2~6¦æ
(2) BºØÃþ¬O¦b8~14¦æ
(3) CºØÃþ¬O¦b16~18¦æ
(4) DºØÃþ¬O¦b20~21¦æ

¦p¦ó¥Î¤½¦¡¦C¥X¦bF2Àx¦s®æ¼g¥X¡G2~6
¥H¤ÎF3,F4,F5ªºÀx¦s®æ©O?

(¦ý¨ä¹ê¥t¤@¤è­±¡A¦pªG¤£¬ÝºØÃþ¡A¥u­nªÅ¤@¦æ¡A´N¦Û°Êºâ¤J¤U¤@­ÓºØÃþ¡C¤]´N¬O»¡¦pªG¤µ¤Ñ¤£¬OABCD¡A¦Ó¬O¨ä¥Lªº¡A¤´¬O¥i¥H§Q¥ÎªÅ¤@¦æ¨Ó§PÂ_´«¤U¤@­ÓºØÃþ¡C)

·Q«ô°U¤j®a´£¨Ñ¤@¨Ç·Qªk¡AÁÂÁ¡C

¬¡­¶Ã¯2.zip (7.74 KB)

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

TOP

¦^´_ 2# hcm19522


ÁÂÁ±zªº¦^ÂСC




·Q¦A½Ð±Ð±z¡G¦bDÄæ¦p¦ó¤U¤½¦¡¡A¤~¯à²£¥Í¦pªþ¹Ïªº¼Æ¾Ú©O?


¦A«ô°U±z©âªÅÀ°¦£¨ó§U¤F¡AÁÂÁ¡C

TOP

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

TOP

¥»©«³Ì«á¥Ñ gaishutsusuru ©ó 2019-9-11 20:28 ½s¿è

¦^´_ 4# hcm19522


ÁÂÁÂhcm19522¤j¤jªºÀ°¦£¡C

¦ý¤U¤È¦b¸ÕµÛ§â¤½¦¡®M¥Î¨ìÀɮ׮ɡA«oÁÙ¬O¤£¯à¶¶§Q¹B§@¡C(¸Ô±¡¦A½Ð±z°Ñ¦Ò¤§«eªºµo¤å¡Ghttp://forum.twbts.com/thread-22026-1-1.html )


¦p¹Ï¡A
¦bR2ªº¤½¦¡¸Ì¦³¡uR$1:R1¡v¡A·Q§â¡uR$1:R1¡v§ï¦¨¥u¼gO2(¦]¬°­È¤]¬OR$1:R1)¡A¦ý¹ê»Ú¾Þ§@®É¡A±N¤½¦¡¤U©Ô«á¡AÀx¦s®æªº­È«o³£ÅܤF¡C¦b·Q»¡¬O¤£¬O¤£¯à³o¼Ëª½±µ®M¥Î©O? (§í©Î¬O±z¦³¨ä¥L§ó¦nªº¤½¦¡©O?)

·Pı´N®t³o»ò¤@ÂIÂI¤F¡A¦ý¤S·Q¤£¥X¤èªk¨Ó¡C«D±`§Æ±æhcm19522¤j¤j¯à¦A¦¸©âªÅ¨ó§U¡AÁÂÁ¡C

ªþ¤WÀɮצp¤U¡C
¬¡­¶Ã¯1.zip (12.27 KB)

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2019-9-12 10:12 ½s¿è

¦^´_ 5# gaishutsusuru

IF(G2="","",IFERROR(LOOKUP(9^9,R$1:R1)

R$1:R1-->INDIRECT($O2)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 6# hcm19522


­ì¨Ó¦p¦¹¡A­ì¨Ó¬O­n³o¼Ë¾Þ§@¡C

¦b¸g¹L´ú¸Õ¥H«á¡A¥i¥H¦¨¥\¤F¡C

¯uªº«D±`ÁÂÁ±zªºÀ°¦£¡AÁÂÁ¡C

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD