IFERROR(IF(),"") ¬°¤°»ò "" ®É COUNTA()=1
- ©«¤l
- 26
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 37
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN T
- ³nÅ骩¥»
- WIN 7
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-4-25
- ³Ì«áµn¿ý
- 2018-12-25
|
IFERROR(IF(),"") ¬°¤°»ò "" ®É COUNTA()=1
¤j¤j½Ð°Ý
¦pªG IFERROR(VLOOKUP(),"") §ä¤£¨ì®É n¥¦Åã¥Ü ""
¥i npºâ ¦³§ä¨ì®É ªº ¤å¦r¸ê®Æ®É
¥Î COUNTA() ¬°¤°»ò ·|¥X²{ ¤]¦³pºâ¤J
¦p
A1=¤j A2=¤p A3="" (VLOOKUP «á,§ä¤£¨ì n¥¦Åã¥Ü ªÅ¥Õ)
npºâ ¦³´XÓ ¤j ¤p ... µ¥ªº ¤å¦r¿é¤J¸ê®Æ
¥Î counta(a1:a3) ·|¥X²{ 3C!
½Ð°Ý ³oÓn«ç»ò °µ©O? |
|
|
|
|
|
|
- ©«¤l
- 26
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 37
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN T
- ³nÅ骩¥»
- WIN 7
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-4-25
- ³Ì«áµn¿ý
- 2018-12-25
|
·P®¦ .................... |
|
|
|
|
|
|
- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2016-6-14 11:38 ½s¿è
¦^´_ 3# §õ§ø¶é
1¡BÀx¦s®æD1¿é¤J¤½¦¡
=IFERROR(IF(ISBLANK(VLOOKUP(C1,A:B,2,)),"",VLOOKUP(C1,A:B,2,)),"")
¦V¤U½Æ»s
ª`¡GISBLANKªº§@¥Î¦b©ó×¹¢VLOOKUP¦^¶Çµ²ªGBÄæ¦ì¬°ªÅÈªÌ (VLOOKUP¦^¶ÇȬ°¡u0¡v)
2¡BpºâÀx¦s®æD1:D7½d³ò¤£¬°¡uªÅÈ¡v¤§Ó¼Æ
=COUNTA(D1:D7)-COUNTBLANK(D1:D7) ---->¨Ì3#¤§±ø¥ó¡Aµª®×¬°¡u3¡v¡C
½Ð°Ñ¦Ò¡I |
|
|
|
|
|
|
- ©«¤l
- 26
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 37
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN T
- ³nÅ骩¥»
- WIN 7
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-4-25
- ³Ì«áµn¿ý
- 2018-12-25
|
¤j¤j±z¦n ...
¨Ò: A1=1 A2=2 A3=3 A4=5 A5=6 A6= A7=
B1=¤j B2= B3= B4=¤¤ B5=¤p B6= B7=
C1=1 C2=2 C3=3 C4=4 C5=5 C6=6 C7=7
D1=iferror(VLOOKUP(C1,A:B,2,FALSE),"") >> ¤j
D2=iferror(VLOOKUP(C2,A:B,2,FALSE) ,"") >> ""
D7=iferror(VLOOKUP(C2,A:B,2,FALSE) ,"") >> ""
pºâ D1~D7 ¦³´XÓ ¤£¬O "" ªº µª®×
§Ú¥Î COUNTA(D17) µª®×·|¬O 7 C ..
§Ú¥Î ¤ñ¸û²Âªº¤è¦¡ ¸Ñ¨M¤F¤@ÂIÂI ¥i µe± ÅܱoÁà¤@¨Ç Åý iferror ªº "" Åܦ¨ 0 ©Î .
¥i§_½Ð°Ý±z ¦pªG Åý iferror ªº µ²ªG ¬O ""
¦³¤°»ò ²³æªº¤è¦¡ pºâ ¤£¬O "" ªº ¥[Á`©O?? |
|
|
|
|
|
|
- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¦^´_ 1# §õ§ø¶é
±z¦n!
¤£©úÁA±zªº°ÝÃD¡A¥i¥H´£¨Ñ½d¨ÒÀÉ¡H
ÁÂÁ¡I |
|
|
|
|
|
|