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

[µo°Ý] «ü©w¥|­Ó¦C¦P®ÉÅã¥Ü¬Y1­Ó(§t)¥H¤W­Èªº"2003ª©"ªº¨ç¼Æ¤½¦¡¡C

[µo°Ý] «ü©w¥|­Ó¦C¦P®ÉÅã¥Ü¬Y1­Ó(§t)¥H¤W­Èªº"2003ª©"ªº¨ç¼Æ¤½¦¡¡C







½d¨ÒªþÀÉ:
4¦C¥æ¶°.rar (3.02 KB)

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2019-1-31 11:04 ½s¿è

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

TOP

¦^´_ 2# hcm19522
hcm¤j¤j:
Sheet1 :¤G´Á¦ì¸m¬Û¦Pªº¼Æ¦r¦³¦P®É¦³¥X²{¥t¤G´Á ~OK¤F!
·PÁ«ü¾É!ÁÂÁÂ!

Sheet2 :¤G´Á¦ì¸m¬Û¦Pªº¼Æ¦r¦³¦P®É¦³¥X²{¥t¤G´Áªº¦PÄæ
¦n¹³º|±¼¤F^^"
½ÐÄ~Äò«ü¾É!ÁÂÁÂ!

TOP

=IF(SUMPRODUCT((OFFSET(B$1,J$1,,,7)=OFFSET(B$1,I$1,,,7))*(OFFSET(B$1,K$1,,,7)=OFFSET(B$1,I$1,,,7))*(OFFSET(B$1,I2,,,7)=OFFSET(B$1,I$1,,,7))),I2,"")
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 4# hcm19522

hcm¤j¤j:
§¹¦¨¤F!ÁÂÁ±z!

TOP

¦^´_ 4# hcm19522

hcm¤j¤j:
¤£¦n·N«ä¡A·Q±NJ2ªº¤½¦¡²Å¦X±ø¥ó1ªºK$1©MI2Åã¥Üªº¬Û¦P¼Æ¦r¡C¶i¶¥¬°¦PÄæ~
¦ý§Ú¥HJ2¤½¦¡²K¤W*OR(OFFSET(B$1,K$1,,,7)=OFFSET(B$1,I2,,,7))¶K¤WK2¤U©Ô¡Aµª®×¤£¥¿½T^^"
½Ð°Ý:K2ªº¤½¦¡­n¦p¦ó½s¼g?
ÁÂÁ±z!



½d¨ÒªþÀÉ :
«á2¦C¦PÄæ¥æ¶°.rar (2.98 KB)

TOP

¦^´_ 6# papaya

=IF(SUMPRODUCT(COUNTIF(OFFSET(B$1,I$1,,,7),OFFSET(B$1,K$1,,,7))*COUNTIF(OFFSET(B$1,J$1,,,7),OFFSET(B$1,K$1,,,7))*(OFFSET(B$1,I2,,,7)=OFFSET(B$1,K$1,,,7))),I2,"")
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 7# hcm19522


hcm¤j¤j:
¥þ³¡OK¤F!
·PÁ­@¤ß«ü¾É!
¯¬:
½Ñ¦~§Ö¼Ö!
¤ß·Q¨Æ¦¨^^

TOP

¦^´_ 7# hcm19522

hcm¤j¤j :
¥i¯à¬O¦]§Úªº»¡©ú¤£²M·¡¡A©Ò¥H¸ÑÃD¤½¦¡¦n¹³¦³»~®t^^"
­«·s»¡©ú¦p¤U:
²Ä1­Ó±ø¥ó~I$1©MJ$1¤G­Ó´Á¼Æªº¦PÄ楲¶·¦³1­Ó(§t)¥H¤Wªº¼Æ¦r¡C
²Ä2­Ó±ø¥ó~²Å¦X²Ä1­Ó±ø¥óªº¼Æ¦r¡A¥²¶·¦³1­Ó(§t)¥H¤W¦P®É¥X²{¦bK$1©MI2¤G­Ó´Á¼Æªº¦PÄæ¡C
§YI$1©MJ$1¦PÄ檺¬Û¦P¼Æ¦r¡A¦³¥X²{¦bK$1©MI2ªº¦PÄæ¡C

K2¤½¦¡·Ð½Ð¦A­×¥¿¡C
ÁÂÁ±z!

TOP

¦^´_ 7# hcm19522
hcm¤j¤j:
¦A¸É¥R»¡©ú:
4#¬OI$1,J$1,K$1,I2³£¦PÄæ¡F
²{¦bªº»Ý¨D¬O¥u­nI$1©MJ$1¦PÄæ¡F¥t¥~K$1©MI2­n¦PÄæ¡C
ÁÂÁ±z!

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD