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

[µo°Ý] ½Æ¼Æ±ø¥ó¥[¤W¤j¤p±Æ§Ç±ø¥ó¸Ó¥Î­þ¨Ç¨ç¼Æ¦Û°Ê±a¤J©O?

[µo°Ý] ½Æ¼Æ±ø¥ó¥[¤W¤j¤p±Æ§Ç±ø¥ó¸Ó¥Î­þ¨Ç¨ç¼Æ¦Û°Ê±a¤J©O?

½Ð°Ý¦U¦ìexcel¨ç¼Æ°ª¤â¡A¦p¦P³o±i¹Ï¤ùÅã¥Ü¡A½Ð°Ý§ÚÀ³¸Ó¥Î­þ¨Ç¨ç¼Æ¦Û°Ê§â¯Z¤W«e¨â¦Wªº¸ê®Æ¦Û°Ê±a¤J¯Z¯Å¡B©m¦W¡B¦W¦¸³o¤TÄæ©O¡H
§Ú¸Õ¹L¥Îvlookupªº¨ç¼Æ¡A¦ý¬O¨º¥u¯à¤@¦¸±a¤J¤@­Ó©Î¤@¾ã±Æªº¸ê®Æ¡A¥i¥H§Ú·Q°µ¨ìªº¬O¨Ì·Ó¯Z¯Å¿ï¥X«e¨â¦W¨Ì§Ç±a¤J¥L­Ì¯Z¯Å¡B©m¦W¡B¦W¦¸³o¤TÄ檺¸ê®Æ¡A½Ð°Ý§Ú¸Ó¨Ï¥Î­þ¨Ç¨ç¼Æ¤½¦¡¤~¯à¹F¦¨»Ý¨D©O?

Q1.jpg (149.28 KB)

Q1.jpg

¸Õ¸Õ¬Ý:¸Õ¸Õ¬Ý:
©w¸q¦WºÙ       
1. ¦P®É¿ï¨ú A1:A10; B1:B10; E1:E10       
2. «ö Ctrl+Shift+F3       
3. ¥u¤Ä¿ï³»ºÝ¦C       
test.gif        
¿é¤J¤½¦¡       
G2=IF(E2<3,LOOKUP(A2&E2,¯Z¯Å&¦W¦¸,¯Z¯Å),"")
H2=IF(E2<3,LOOKUP(A2&E2,¯Z¯Å&¦W¦¸,©m¦W),"")
I2=IF(E2<3,LOOKUP(A2&E2,¯Z¯Å&¦W¦¸,¦W¦¸),"")

TOP

http://blog.xuite.net/hcm19522/twblog/366599220

TOP

¬Ý¤F hcm19522 ¤j¤j¥H«á, ¤~¹îı¨ì,§Úªº¤½¦¡¦³°ÝÃD,
¥R¨ä¶q¥u¯à¦b¦P¦C¤¤«ü¥X«e2¦W¦b¨º¸Ì,
¨Ã¥¼¯u¥¿§ì¥X«e2¦W¨ì·sªí®æ¤¤,
¬Ý¨Ó¤S­n¦n¦n¬ã¨s hcm19522 ¤j¤jªº¤½¦¡¤F.
ÁÂÁ hcm19522 ¤j¤j!! ¦³¤£À´ªº¦a¤èÁÙ±æ¤j¤j«ü¾É!!

TOP

http://blog.xuite.net/hcm19522/twblog/366642247
°Ñ¦ÒÃD
¸Ì¦³»²§U³¡¤À ½Ð "¤j¤j­Ì"«üÂI  ¥i§_¤£¥Î»²§U ¨ä·N¬° ­YA1:A2="A" ,A3:A4="B" ,A5:A7="A" ,A8="B" ,¦p¦óÅýµ{¦¡ "¤Ï¥Õ" ,«öF9Åã {1;2;1;2;3;4;5;3} »P=COUNTIF(A$1:A1,A1) ¤U©Ô¦P·N«ä ,¦¹°ÝÃD¸Ñ¨M ´N¥i¤£¥Î»²§U

TOP

¦^´_ 3# hcm19522
¤j¤j§A¦n,
¦b¬ã¨s¤j¤jªº¤½¦¡®É, µo²{·s°ÝÃD,
§Q¥Î¤j¤jªºªí®æ, ©T©w¯Z¦W¤Î¦W¦¸, ¥i¥H¸Ñ¨M
§ì¨ì¦¨ÁZ¤Î¦W¦¸ªº°ÝÃD, ¦ý¦pªG¦³¦P¦W¦¸¸Ó¦p¦ó¸Ñ?

TOP

¦^´_ 7# yen956
http://blog.xuite.net/hcm19522/twblog/366835403
°Ñ¦Ò

TOP

¦^´_ 6# hcm19522

»¼¼W­Ó¼Æ¡G
=COUNTIF(OFFSET(B$1,1,,ROW(C$2:C$16)-1),B$2:B$16)

±Æ¦W°}¦C¡G
=MMULT(N((B$2:B$16=TRANSPOSE(B$2:B$16))*TRANSPOSE(C$2:C$16)>(C$2:C$16)),(ROW(C$2:C$16))^0)+1

TOP

¦^´_ 8# hcm19522
ÁÂÁ¤j¤j§Ö³tªº¦^ÂÐ, ¥ý¦¬¤U, µ¥¥H«áªº¥H«á¦A¬ã¨s, ÁÂÁÂ!!

TOP

¥»©«³Ì«á¥Ñ kaui700 ©ó 2015-12-21 20:47 ½s¿è

ÁÂÁ¦U¦ì°ª¤âªº¼ö±¡¥æ¬y¡A¾Ç¨ì¦n¦hªF¦è¡Ayen956¤j¤j°Ýªº¦P¤À±Æ¦W°ÝÃD¡A¤]¬O§Ú·Q°Ýªº¦a¤è¡A±zªº¸ß°ÝÅý§Ú¾Ç¨ì«Ü¦h­«­nªºÆ[©À¡A§ó­n¯S§O·PÁÂhcm19522¤j¤j¡A±z¤£¦ýÀ°¦£´£¨Ñ³\¦h¸Ñ¨M¤è®×¡A¦b±zªº³¡¸¨®æ¸Ì­±ÁÙ´£¨Ñ¤F¦n¦hÂ×´Iªºexcel±Ð¾Ç¡AÅý§Ú¦¬Ã¬º¡º¡¡A·P®¦

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD