- ©«¤l
- 967
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1001
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-11-29
- ³Ì«áµn¿ý
- 2022-5-17
|
¦^´_ 3# jj369963
Hsieh¶Wª©¤§µª®×
¦p¹Ï
1.´¡¤JA,B¨âÄæªÅ¥ÕÄæ
2.A38=INDIRECT("C"&MIN(IF(ISERROR(MATCH($C$1:$C$30,$A$37:A37,0)),ROW($C$1:$C$30),"")))
°}¦C¤½¦¡(¤½¦¡¿é¤J¦n¶·«öCtrl+Shift+Enter²Õ¦XÁä)
©¹¤U½Æ»s¨ìA43
B39=SUM(COUNTIF($C$1:$C$30,$A$39:A39))
°}¦C¤½¦¡(¤½¦¡¿é¤J¦n¶·«öCtrl+Shift+Enter²Õ¦XÁä)
©¹¤U½Æ»s¨ìB43
C38=IF(ROW(A1)>MAX($B$39:$B$43),"",LOOKUP(ROW(A1),$B$39:$B$43-$B$39+1,$A$39:$A$43))
°}¦C¤½¦¡(¤½¦¡¿é¤J¦n¶·«öCtrl+Shift+Enter²Õ¦XÁä)
©¹¤U½Æ»s
D38=IF($C38="","",INDIRECT("R"&SMALL(IF($C$1:$C$30=$C38,ROW($C$1:$C$30),""),COUNTIF($C$38:$C38,$C38))&"C",0)&"")
°}¦C¤½¦¡(¤½¦¡¿é¤J¦n¶·«öCtrl+Shift+Enter²Õ¦XÁä)
©¹¤U½Æ»s,©¹¥k½Æ»s |
|