- ©«¤l
- 560
- ¥DÃD
- 159
- ºëµØ
- 0
- ¿n¤À
- 723
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS
- ³nÅ骩¥»
- xp
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2014-9-10
- ³Ì«áµn¿ý
- 2023-10-31
|
DEAR SIR
1E5©ñ¦p¤U¨ç¼Æ«á°}¦C«á¤U©Ô§Y¥i .
1.1 °}¦C = SHIFT + CTRL+ENTER
=IF(ISERROR(INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$B$4B$100=$E$4,ROW(Sheet1!$A$1A$28),""),ROW(A1)))),"",INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$B$1B$28=$E$4,ROW(Sheet1!$A$1A$28),""),ROW($A1)))) |
|