ªð¦^¦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

4¦C¥æ¶°_1.png
2019-1-30 18:54



4¦C¥æ¶°_2.png
2019-1-30 18:54



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

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

https://blog.xuite.net/hcm19522/twblog/586673910
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

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,"")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

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!

«á2¦C¦PÄæ¥æ¶°.png
2019-2-2 07:13


½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,"")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

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¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD