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

[µo°Ý] Excel ®w¦sºÞ²z¤½¦¡³B²z³t«×°ÝÃD

[µo°Ý] Excel ®w¦sºÞ²z¤½¦¡³B²z³t«×°ÝÃD

Dear all,

¤j®a¦n¡A¤p§Ì³]­p¤F¤@­ÓExcel³B²z®w©Ð¶i¥X±bªº¸ê®Æ®w¡C¨Ã°µ¤F¤@­Ó¤u§@ªí"1°Ï"

¤u§@ªí"1°Ï"¥D­n¬O¦b§ì"¸ê®Æ®wªº³Ì«á¤@µ§¸ê®Æª¬ªp¡A§Ú¬O¥ÎLOOKUP¤è¦¡¥h§ì¡A¦ý¬O²{¦b¦b¿é¤J¸ê°T®É¡AExcel´N·|¶]«Ü¤[

¬O§_¥i¥H¨ó§U§Ú¬Ý¤@¤U¤½¦¡¡A¬O§_¦³¥i¥H¦A²¤Æªº³¡¤À¡A¤w¥[±jexcel³B²z¸ê®Æ³t«×

·PÁ¤j®aªºÀ°¦£¡I

2020_¦Û°Ê­ÜÀxÀx¦ìºûÅ@ªí-Vre1.rar (46.85 KB)

2020_¦Û°Ê­ÜÀxÀx¦ìºûÅ@ªí-Vre1.gif
Just do it.

1) §Q¥Î©w¸q¦WºÙ§ì¸ê®Æ¹ê»Ú½d³ò
2) §Q¥Î»²§U¤½¦¡§ì³Ì«á¤@µ§ªº¦ì¸m(»²§UÄæ¥iÁôÂÃ, ©Î±N¤å¦r³]¬°¥Õ¦â)
Xl0000013.rar (47.67 KB)

TOP

¦^´_ 2# ­ã´£³¡ªL
Dear ­ã´£³¡ªL,
±z¦n¡I±z¯uªºÀ°§Ú¸Ñ¨M«Ü¤jªº°ÝÃD¡A¯uªº«Ü·PÁ±z¡I

¬O§_¥i¥H½Ð±z±Ð±Ð§Ú¡A§Ú¤£¤ÓÀ´³o·N«ä


1) §Q¥Î©w¸q¦WºÙ§ì¸ê®Æ¹ê»Ú½d³ò --> ³o¤@³¡¤ÀOK
2) §Q¥Î»²§U¤½¦¡§ì³Ì«á¤@µ§ªº¦ì¸m(»²§UÄæ¥iÁôÂÃ, ©Î±N¤å¦r³]¬°¥Õ¦â) --> ³o¤@³¡¤À¬O§_¥i±Ð¾É
=LOOKUP("z",IF({1,0},"",MATCH(1,0/(xClmnB=J3))&""))


Thank you.



³oºô¯¸¯uªºÀ°§Ú«Ü¦h«Ü¦h¡A·PÁ©Ҧ³±Ð¾Éªº¦Ñ®v¡A¯uªº·P®¦¡I
Just do it.

TOP

¦^´_ 2# ­ã´£³¡ªL
Dear ­ã´£³¡ªL,
±z¦n¡I©êºp¦A°l¥[¤@­Ó°ÝÃD¸ò±z½Ð±Ð
§Ú¬Ý±z©Ò³]­pªºEXCELÀÉ®×Ãþ«¬¬°2003ª©¥»¡A¬O§_¬O¦³¬Û®e©Ê©Î¬O¨ä¥L¦]¯À¦Ò¶q¶Ü¡H
ÁÂÁ±z¡I
Just do it.

TOP

¦^´_ 4# jsc0518

¦]À³¤½¥q¥þ³¡ªºPCÀô¹Ò, ¥Ø«eÁ٨ϥÎ2000ª©:
=LOOKUP("z",IF({1,0},"",MATCH(1,0/(xClmnB=J3))&""))

2007¥H¤W¥i§ï¬°
=iferror(MATCH(1,0/(xClmnB=J3)),"")

TOP

¦^´_ 5# ­ã´£³¡ªL
Dear ­ã´£³¡ªL,
±z¦n¡I·PÁ±zªº»¡©ú¡C
§Ú·|¾Ç°_¨Ó¹B¥Îªº
·P®¦¡I
Just do it.

TOP

¦^´_ 2# ­ã´£³¡ªL

Dear ­ã´£³¡ªL,

§Ú¦b¤u§@ªí"1°Ï"¡A±N½ckgÄæ¦ì­n°µ¥[Á`¡A¦ý¨Ï¥Îsum¤½¦¡µ²ªG¬°0
¨Ï¥Î¤@­ÓÄæ¦ì+¤@­ÓÄæ¦ì¡Aµ²ªG¥¿±`
­þ¸Ì»Ý­×­q¹L©O¡H


***§Ú¦³¸Õ¹L±N¸ÓÄæ¦Cªº­È¡A½Æ»s¦Ü¥t¤@­Ó¤u§@ªí¤W(½Æ»s-¿ï¾Ü©Ê¶K¤W-­È)¡Aµo²{¨º¨Ç¦³¼Æ¦rªºÄæ¦ì¨äÀx¦s®æ¬°¤å¦r

Thank you very much.

111.gif
Just do it.

TOP

¦^´_ 7# jsc0518

=IF(OR(A3="",C3="¶¢¸m"),"",INDEX(¸ê®Æ®w!$H:$H,A3)&"")
±N¬õ¦â³¡¥÷¥h±¼§Y¥i¥[Á`~~

©Î¥Î:
=SUMPRODUCT(--(0&H39:H47))

TOP

¦^´_ 8# ­ã´£³¡ªL

Dear ­ã´£³¡ªL,
¦nªº¡A¤F¸Ñ¡C·PÁ±z¡I  ^_^
Just do it.

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD