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

¤U©Ô¿ï³æ¹ïÀ³

¤U©Ô¿ï³æ¹ïÀ³

¦h­Ó¤U©Ô¿ï³æ¦Û°Ê¹ïÀ³
¥Î¨ç¼Æ¥i°µ?
½Ð¦U¦ì°ª¤â±Ð¾É,·P¿E

´ú¸Õ.rar (3.34 KB)

´ú¸Õ.rar (3.34 KB)

´ú¸Õ.rar (3.34 KB)

¸Õ¸Õ¬Ý
´ú¸Õ.zip (5.99 KB)

TOP

½Ð±Ðfengetianxia¤j
¦^¶Çªº´ú¸ÕÀÉ¥i¦Û°ÊÅã¥Ü¬P´Á
·í¥N¤J¥tÀɮ׫á¤S¤£¦æ,
½ÐF¤j©Î¦U¦ì°ª¤â±Ð¾É,·P¿E

´ú¸Õªí.rar (7.08 KB)

TOP

[i=s] ¥»©«³Ì«á¥Ñ fengetianxia ©ó 2016-10-19 16:01 ½s¿è [/i]

[b]¦^´_ [url=http://forum.twbts.com/redirect.php?goto=findpost&pid=94883&ptid=18577]4#[/url] [i]ws2315[/i] [/b]

  ±NG12®æ¦¡§ï¬°³q¥Î®æ¦¡
  µM«áG12ªº¤½¦¡,±N¶}©lªºSheet1!D:D §ï¦¨ Sheet1!F:F

TOP

´ú¸Õªí.zip (7.52 KB)

TOP

¢Õ¢°¢±¡G¬P´Á¤½¦¡
=TEXT("r"&SUBSTITUTE(C12&E12&F12," ",),"(aaaa);;;")
¡@
¡@

TOP

½Ð±Ðfengetianxia¤j
ÂI¿ï¦~ ¤ë  ¤é  ¤p®É «á
H7 H10Äæ ·|¦Û°ÊÅã¥Ü ¤é  ¤p®É

½ÐF¤j©Î¦U¦ì°ª¤â±Ð¾É,·P¿E

´ú¸Õªí.rar (6.81 KB)

TOP

©êºp,¦]®É¶¡¤£¤@­P ²Ä¤@­Ó°ÝÃD´N¤£¥Î¤F
½Ð°Ý¦U¦ì°ª¤â¤U­±°ÝÃD:
¨C¦¸¶}±ÒÀÉ®×,µL¥ô¦ó°Ê§@,ª½«öÃö³¬
¥X²{XXX.XLS¤v³Q­×¥¿¹L,±z¬O§_­nÀx¦sÀÉ®×?

´ú¸Õ.rar (5.11 KB)

TOP

¦^´_ 9# ws2315


¨Ï¥ÎOFFSET, INDIRECT, NOW, TODAY....³£·|³y¦¨ÃöÀÉ´£¥ÜÀx¦s¡A
¥i§ï¦¨ª½±µ°Ñ·Ó¡G   
¢Ð¢µ¡G=IF(Sheet2!E$1=$B$8,Sheet2!E3,Sheet2!E2)
¢Ð¢¶¡G=IF(Sheet2!I$1=$B$8,Sheet2!I3,Sheet2!I2)

TOP

´ú¸Õªík.zip (7.26 KB)

TOP

        ÀR«ä¦Û¦b : ¦a¤WºØ¤Fµæ¡A´N¤£©öªø¯ó¡F¤ß¤¤¦³µ½¡A´N¤£©ö¥Í´c¡C
ªð¦^¦Cªí ¤W¤@¥DÃD