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

[¤À¨É] ¬¡°Ê¦¡¹Ïªí²©ö±Ð¾Ç

[¤À¨É] ¬¡°Ê¦¡¹Ïªí²©ö±Ð¾Ç


ÂIÀ»±²¶b®É,¹Ïªí¤º®e·|¸òµÛ§ó·s.
°£¤F§é½u¹Ï,¤]¥i¥H´«¦¨¨ä¥L¹ÏªíÃþ«¬´ú¸Õ¬Ý¬Ý,·|¦³¤£¦Pªº®ÄªG.

sample.rar (69.86 KB)

¤£¿ùªº¸ê®Æ¡A·PÁ¤À¨É¡A

TOP

·Q¦n¦n¾Ç²ßEXCEL¡A¦ý¹ê¦b©â¤£¥X®É¶¡¥´¦n°ò¦¡A·Q­n´£°Ý.....¤S©È³Q»¡¤£¥ý¦æª¦¤å¡A»¡¯uªº®É¶¡¤£°÷§Úª¦¤å¡A³Ìªñ¦³ªÅª¦¤å¡A³o½g¤å³¹¹ï§Ú§U¯q¯u¤j¡AÁÂÁ¦U¦ì....

TOP

¥Îoffset°µªº¶Ü?
³o­Ó½d¨Ò¬Ý°_¨Ó«ÜÆg³á

TOP

¤p§ÌµLªk¤U¸üÀɮסA¤£ª¾¥ý¶i¥i§_±HÀɮצܤp§Ì«H½c¡AÁÂÁÂ...!!!
«H½c¡G[email protected]

TOP

¦^´_ 5# cw3076

  
©w¸q¦WºÙ[¸ê®Æ]¤½¦¡
=OFFSET(®y¼Ð,,IF(¦¨«~­¶­±!$G$3="¨}²v",1,2),,)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Hello Jack,
  °µªº¯u´Î, ·PÁ§Aªº¤À¨É.
  ¥t¦pªG¸ê®Æ¦³¦n¦h­Ó¥i¥H¤]°µ¿ï¾Ü¶Ü?
  (¨Ò¦p¦³ ¨}²v1,¨}²v2,¨}²v3..)

TOP

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD