- ©«¤l
- 228
- ¥DÃD
- 37
- ºëµØ
- 0
- ¿n¤À
- 297
- ÂI¦W
- 20
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2015-2-20
- ³Ì«áµn¿ý
- 2024-4-22
|
¦^´_ 7# hcm19522
«D±`·PÁÂ hcm19522 ¦^ÂÐ
¤å¤¤ªþ¦³¤GºØ
¸Ñµª¤è¦¡...¤@ºØ¦³ª÷ÃB³æ¦ì¡A¥t¤@ºØµLª÷ÃB³æ¦ìÅã¥Ü ¥i¨Ñ°Ñ¦Ò³á ^^
«ü¾É¦X¨Ö®æ¤½¦¡°µªk :¤½¦¡¤U¦X¨Ö®æB2:C2 ¥Î¶ñº¡¤è¦¡ ¤£¥Î½Æ»s-->ENTER-->°é¿ïB2:AD2(¦X¨Ö®æ)-->´å¼Ð©ñ¤½¦¡§À-->ctrl+enter¤GÁä¤@°_«ö-->¥Ñ¥ª¦Ü¥k ¤@¦C¤@¦C ¤U©Ô
PS: ¦X¨Ö¤½¦¡{=IF($FY10="","",LEFT(RIGHT(" $"&$FY10,12-COLUMN(J1)/10)))
½Ð°Ý¤½¦¡¤¤ COLUMN(J1)/10 ·NÄÀ¬°? |
|