- ©«¤l
- 169
- ¥DÃD
- 39
- ºëµØ
- 0
- ¿n¤À
- 252
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-4-17
- ³Ì«áµn¿ý
- 2020-7-17
|
¦^´_ 2# play9091
ÁÂÁ¤j¤jªº×§ï«Øij¡A¦ý¬O¡A ¤p§Ì¦bAÄæ¨Ï¥Îªº¨ç¼Æ=TEXT(B2,"mm")&"-"&TEXT(SUMPRODUCT((TEXT($B$1:$B2,"yymm")=TEXT(B2,"yymm"))*1),"000")¡A¸ê®Æ¤£Âà¼g¨«ªº¸Ü¡A¨S°ÝÃDªº¡A
¥i¬O SHEET1ªºAÄæ¨ç¼Æ¬O·|ÀHµÛÂà¼g¨«ªº¸ê®ÆÅÜ°Ê«±Æ¡A©Ò¥H¤p§Ì§Æ±æ¯à¦bAÄæ¨Ï¥ÎVBA¬y¤ô¸¹¡A |
|