ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ´£¨ú¥k°¼ª÷ÃB¬ÛÃö¼Æ¦r¦Ü¬ÛÃöª÷ÃBÄæ¦ì

[µo°Ý] ´£¨ú¥k°¼ª÷ÃB¬ÛÃö¼Æ¦r¦Ü¬ÛÃöª÷ÃBÄæ¦ì

´£¨ú¥k°¼ª÷ÃB¬ÛÃö¼Æ¦r¦Ü¬ÛÃöª÷ÃBÄæ¦ì

¦]Äæ¦ì¶W¹L150Äæ
¥Bª÷ÃB¼Æ¦r¦b¥k°¼¿é¤J...
C10Àx¦s©Ò³]¤½¦¡(¨Õ»õ³B)
=IF($EX10="","",LEFT(RIGHT(" $"&$EX10*100,150-COLUMN()),1))

¸Ó¤½¦¡­n¦p¦ó­×¥¿¤~¯à¥¿±`Åã¥Ü  ??
©Î¬O¥Î¨ä¥L¤½¦¡¤è¦¡³B²z...

0204.rar (12.07 KB)

C10//
=IF($EX10="","",LEFT(RIGHT(" $"&$EX10,COLUMNS(C:$CA)/7)))
¥k©Ô

TOP

¦^´_ 2# ­ã´£³¡ªL

·PÁª©¥D  ­ã´£³¡ªL  @¦^ÂР ^^

­ì¨Ó®t²§³B¬O COLUMNS(C:$CA)/7
ª÷ÃBIJ½d³ò   C:$CA °£¥H ¨C¤@¦X¨ÖÀx¦s®æ¦³  7  Äæ
Àò¯q¨}¦h  ^^

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 4# hcm19522

·PÁ  hcm19522 «ü¾É¦^ÂÐ
¥t¦³¸Ñµª¤è¦¡...column  ¥i¨Ñ°Ñ¦Ò³á  ^^

TOP

¦^´_ 4# hcm19522

©Ó¤W°ÝÃD©Ò­z...

´£¨ú¥k°¼ª÷ÃB¬ÛÃö¼Æ¦r¦Ü¬ÛÃöª÷ÃBÄæ¦ì



¤µ¦]®MªíÃö«Y²Ä 10 ¦C¦ì¬ÛÃöÄæ¦ì¼Æª÷ÃB³æ¦ì­Ó¼Æ¤£¤@®É
¥Bª÷ÃB¼Æ¦r¦b¥k°¼¿é¤J...
C10Àx¦s©Ò³]¤½¦¡(¨Õ»õ³B)¥k©Ô¤½¦¡¸Ó¦p¦ó­×¥¿?

0228.rar (12.14 KB)

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2023-3-1 11:09 ½s¿è

¦X¨Ö®æ®t§O¦h ¥i¯à¦³»~    ¦X¨Ö¤½¦¡{=IF($FY10="","",LEFT(RIGHT(" $"&$FY10,12-COLUMN(J1)/10)))

https://blog.xuite.net/hcm19522/twblog/590743030
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 6# cypd

­ì¥ý¤½¦¡ C10 =IF($FY10="","",LEFT(RIGHT(" $"&$FY10,COLUMNS(C:$DB)/9)))
³o¤½¦¡¬OOKªº

«D§¡¤Ã¦X¨Ö®æ¼Æ¿é¤J¤è¦¡¤£¯à¥Î©Ôªº¡A¿é¤J¤èªk¦p¤U
1 C10 ¿é¤J¤½¦¡
2 ¿ï¨ú¥þ³¡¦X¨Ö®æ
3 ÂI¿ï½s¿è¦C¤½¦¡¡A«ö CTRL+ENTER ¿é¤J¤½¦¡

¦X¨Ö®æ¤£§¡¤Ã 9®æ¡B10®æ¡B9®æ¡B10®æ ...
¨Ï¥Î /9 ¦bRIGHT¨ç¼Æ®É¦Û°Ê¨ú¾ã¼Æ¡A©Ò¥H¦b19­Ó¦X¨Ö®æ¸Ì­±¨Ï¥Î¬OOKªº¡A¶W¹L¦¹¤½¦¡´N·|¦³ÂI¤p¿ù»~¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 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ÄÀ¬°?

TOP

¦^´_ 8# ML089

·PÁÂ ML089 ¦^ÂÐ
¨Ã»¡©ú«ü¾É¦X¨Ö®æ¤½¦¡¿é¤J¤Î°µªk
¦X¨Ö®æ¤£§¡¤Ã 9®æ¡B10®æ¡B9®æ¡B10®æ ...
¨Ï¥Î /9 ¦bRIGHT¨ç¼Æ®É¦Û°Ê¨ú¾ã¼Æ¡A©Ò¥H¦b19­Ó¦X¨Ö®æ¸Ì­±¨Ï¥Î¬OOKªº¡A¶W¹L¦¹¤½¦¡´N·|¦³ÂI¤p¿ù»~¡C(­n¯S§O¯d·N¡K)

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD