¿é¤J¬Û¦P½s¸¹®É, ¦Û°ÊÅã¥Ü¤W¤@µ§»ÈÃB
- ©«¤l
- 207
- ¥DÃD
- 61
- ºëµØ
- 0
- ¿n¤À
- 270
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-3-20
- ³Ì«áµn¿ý
- 2023-6-25
|
¿é¤J¬Û¦P½s¸¹®É, ¦Û°ÊÅã¥Ü¤W¤@µ§»ÈÃB
|
|
|
|
|
|
- ©«¤l
- 93
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 134
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS7
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-3-21
- ³Ì«áµn¿ý
- 2020-11-30
|
=LOOKUP(1,0/(B$2:B3=B4),D$2:D3) |
|
|
|
|
|
|
- ©«¤l
- 207
- ¥DÃD
- 61
- ºëµØ
- 0
- ¿n¤À
- 270
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-3-20
- ³Ì«áµn¿ý
- 2023-6-25
|
¦^´_ 2# fengetianxia
¦¹¤½¦¡¤£¦æ
¦]¬°¸ê®Æ«ùÄò¼W¥[¤¤. |
|
|
|
|
|
|
- ©«¤l
- 1391
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1401
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-12-16
|
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|
- ©«¤l
- 207
- ¥DÃD
- 61
- ºëµØ
- 0
- ¿n¤À
- 270
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-3-20
- ³Ì«áµn¿ý
- 2023-6-25
|
¦^´_ 4# hcm19522
µª®×¥¿½T, ÁÂÁÂ! |
|
|
|
|
|
|
- ©«¤l
- 132
- ¥DÃD
- 31
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taipei
- µù¥U®É¶¡
- 2011-4-14
- ³Ì«áµn¿ý
- 2024-2-28
|
¦^´_ 4# hcm19522
½Ð±Ð¤@¤Uhcm19522¤j¤j¡G
«ôŪ¤Fµ{¦¡¡A¥i¬O¤£¤F¸Ñ0/(B$1:B6=B7)³oÓªº¨Ï¥Î¤âªk¡A¤£ª¾¹D¯à§_¸Ñ»¡¤@¤U©O¡H·PÁ±z¡C |
|
clio
|
|
|
|
|
- ©«¤l
- 1391
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1401
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-12-16
|
¥»©«³Ì«á¥Ñ hcm19522 ©ó 2017-8-29 19:04 ½s¿è
¦^´_ 6# clio
(¤@)¨Ò :LOOKUP(A1,{1,5,9},{"A","B","C"})-->A1=1~4-->"A" ,5~8-->"B" ,9(§t)¥H¤W-->"C"-->¥t¸Ñ 1(§t)¥H¤W¬OA ;5(§t)¥H¤W¬OB ;9(§t)¥H¤W¬OC ;<1 ¿ù»~
(¤G)±ø¥ó¦¨¥ß¬°¯u(TURE) ±ø¥ó¤£¦¨¥ß¬°°² (FALSE)-->LOOKUP(1,0/±ø¥ó¬O§_¦¨¥ß,¹ïÀ³¦C)-->0/TURE©ÎFALSE-->0»PµL·N¸q-->LOOKUP§ä¨ì³Ì«á¤@Ó¬°¯u .¬°0 ªÌ
¨Ò :A1:A5={1,2,3,4,5}-->LOOKUP(1,0/(A1:A5<3),{11,12,13,14,15})-->0/(A1:A5<3)²£¥Í{0,0,µL·N¸q,µL·N¸q,µL·N¸q}-->§ä¨ì³Ì«á¤@Ó¬°¯u .¬°0 ¬O²Ä¤G¦ì¸mªº¹ïÀ³¦C 12 |
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|
- ©«¤l
- 132
- ¥DÃD
- 31
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taipei
- µù¥U®É¶¡
- 2011-4-14
- ³Ì«áµn¿ý
- 2024-2-28
|
¦^´_ 7# hcm19522
·PÁÂHcm19522ªº¸Ô²Ó¸ÑÄÀ¡A³o¼Ë§Ú²M·¡¤F¡ALOOKUP(5,0/(B$1:B3=B4),D$1:D3))¬O§ä¥X³Ì«á¤@µ§¬°¯uªº¸ê®Æ¡A¨º°²¦pn§ä²Ä¤@µ§©O¡H¥i¥H«ç»ò×¥¿©O¡H |
|
clio
|
|
|
|
|
- ©«¤l
- 1391
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1401
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-12-16
|
¦^´_ 8# clio
INDEX(D$1:D3,MATCH(,0/(B$1:B3=B4),))
OR
INDEX(D:D,MATCH(,0/(B$1:B3=B4),)) |
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|
- ©«¤l
- 132
- ¥DÃD
- 31
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taipei
- µù¥U®É¶¡
- 2011-4-14
- ³Ì«áµn¿ý
- 2024-2-28
|
¦^´_ 9# hcm19522
¤F¸Ñ¡K·PÁÂhcm19522¡A³o¼Ë§Ú´N§¹¥þ¤F¸Ñ¤F¡A·PÁ±z@¤ßªº¸Ñ»¡ |
|
clio
|
|
|
|
|