- ©«¤l
- 522
- ¥DÃD
- 36
- ºëµØ
- 1
- ¿n¤À
- 603
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp sp3
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-12-13
- ³Ì«áµn¿ý
- 2021-7-11
|
¥»©«³Ì«á¥Ñ yen956 ©ó 2014-5-23 10:45 ½s¿è
¦^´_ 3# p212
¸Õ¤F¥b¤Ñ, ²×©ó¸Õ¥X¨Ó, ì¨Ó§Ñ¤F±N[R1C1]Äæ¦W¦C¸¹ªí¥Üªkªº¤Ä¤Ä¥h±¼,
ÁÂÁ¤j¤jªº«ü¾É, ÁÂÁÂ!!
¤S,- 4¡BY¨Ï¥ÎExcel 2007ª©¥»¥H«áªÌ¡AÀx¦s®æD2¥i¿é¤J°}¦C¤½¦¡
- {=IFERROR(INDEX(»²§UÄæ,MATCH(0,COUNTIF($D$1:D1,»²§UÄæ),0)),"")}
½Æ»s¥N½X ¦¹¤½¦¡¦bExcel 2007ª©¥»¥H«á, ¤£§ï¤½¦¡¥i¦æ¶Ü?
§Y, ¤½¦¡ {=IF(ISNA(MATCH(0,COUNTIF($D$1:D1,»²§UÄæ),0)),"",INDEX(»²§UÄæ,MATCH(0,COUNTIF($D$1:D1,»²§UÄæ),0)))}
¦bExcel 2007ª©¥»¥H«á¥i¦æ¶Ü? |
|