¦p¦ó¹ïÀH¾÷±Æ¦C¤§¤å¦r«¬¼Æ¦r¶i¦æ±Æ§Ç¡H
- ©«¤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
![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2013³D¦~¥þ¶Ô¼ú³¹ 2013³D¦~¥þ¶Ô¼ú³¹](images/common/she.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif)
|
¦p¦ó¹ïÀH¾÷±Æ¦C¤§¤å¦r«¬¼Æ¦r¶i¦æ±Æ§Ç¡H
¥»©«³Ì«á¥Ñ p212 ©ó 2014-1-16 10:34 ½s¿è
¦p¦óÀ³¥Î«D°}¦C«¬²Õ¦X¤½¦¡¹ïÀH¾÷±Æ¦C¤§¤å¦r«¬¼Æ¦r¶i¦æ±Æ§Ç¡H |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
![½×¾ÂºaÅA¾±³¹ ½×¾ÂºaÅA¾±³¹](images/common/medal14.gif) ![½×¾ÂÃÙ§U¾±³¹ ½×¾ÂÃÙ§U¾±³¹](images/common/medal3.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif) ![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2015¦Ï¦~¥þ¶Ô¼ú³¹ 2015¦Ï¦~¥þ¶Ô¼ú³¹](images/common/yang.gif) ![2016µU¦~¥þ¶Ô¼ú³¹ 2016µU¦~¥þ¶Ô¼ú³¹](images/common/hou.gif)
|
B2
=IF(A2="","",SUMPRODUCT((--A2>--A$2:A$11)*(A$2:A$11<>""))+1+COUNTIF(A$1:A1,A2)) |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤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
![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2013³D¦~¥þ¶Ô¼ú³¹ 2013³D¦~¥þ¶Ô¼ú³¹](images/common/she.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif)
|
¥»©«³Ì«á¥Ñ p212 ©ó 2014-1-17 11:54 ½s¿è
¦^´_ 3# Hsieh
·PÁÂHsieh¶W¯Åª©¥Dªº«ü¾É¡I
¤µYSheet1!$A$2:$A$11½d³ò¤º¦³Àx¦s®æ¬°¡uªÅ®æ¡v(§Y¸ê®Æ¬°«D³sÄò©Ê§e²{)¡A¦Ó¸Ó¡uªÅ®æ¡v¤£°Ñ»P±Æ§Ç (¨Ì3#ªº¸Ñªk¡uªÅ®æ¡v±Æ§Çµ²ªGȧ¡¬°¡u1¡v)¡A½Ð°Ý¨ä±Æ§Ç¤½¦¡¤SÀ³¦p¦óקï¡H
·Ð½Ð½ç±Ð¡AÁÂÁ¡I |
|
|
|
|
|
|
- ©«¤l
- 129
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 178
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-12-28
- ³Ì«áµn¿ý
- 2018-11-10
|
¦^´_ 1# p212
b2 {=MATCH(VALUE(A2),SMALL(VALUE(A$2:A$11),ROW($1:$10)),0)+COUNTIF(A$2:A2,A2)-1}
¤U©Ô |
|
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|