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

[µo°Ý] ¦p¦ó²¤Æ¤½¦¡¨ç¼Æø»s¹Ïªí

[µo°Ý] ¦p¦ó²¤Æ¤½¦¡¨ç¼Æø»s¹Ïªí

¦U¦ì¤j¤j¦n¡A¤p§Ì³Ìªñ·Qø»s¨Ï¥Î¤½¦¡©Ò²£¥Íªº¹Ïªí
¤@¯ë³£¬O¨Ï¥ÎÀx¦s®æÂI´yø¤è¦¡¨Óø»s
§Ú·Q½Ð°Ý¬O§_¦³¿ìªk¶Èµ¹¤©³Ì¤j³Ì¤p½d³ò¡A¦Û¦æø»s¹Ïªí(¤£¶·ª¾¹D¤º³¡¦UÂI¸ê®Æ)
½d¨Ò¦p¤U¡G¤U¦C¹Ïªí¬O¨Ï¥ÎA»PB¦C©Òø»s¹Ï§Î¡A§Ú»Ý¥ýºâ¥X¨C­ÓÂIªº¦ì¸m¡A¦A¨Ï¥Î¹Ïªíø»s


§Æ±æ¡G§ï¥ÑE»PF¡A¶Èª¾¹D¤½¦¡¨Ãµ¹¤©¤W¤U¼Ð¬É§Y¥iø»s¾ã±i¹Ï§Î¡A¦Ó¤£»Ý¨DÂI¡A²¤Æ¹Ïªí
ÁÂÁ¤j®a

¨ç¼Æ¹Ï§Î.rar (11.29 KB)

¢Ó¢±¡G-10
¢Ó¢²¡G10
¢Ï¢²¡G=IF(MAX(A$2:A2)=E$3,"",E$2+ROW(A1)-1)
¢Ð¢²¡G=IF(A3="","",A3^2)

©w¸q¦WºÙ¡DxBase¡G=OFFSET($A$3,,,COUNT($A:$A))¡@¹Ïªí¨Ó·½°Ñ·Ó¦ì§}

TOP

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

¹ï¤£°_¡A¤j¤j¡A¥i¯à»~·|§Úªº·N«ä
§Úªº§Æ±æ¬O¶È³Ñ¤UE»PFÀx¦s®æ¡AA»PBÄæ¦ì¬O§R°£±¼ªº

TOP

¹ï¹Ïªí¤£¤Ó¤W¤â, °Ñ¦Ò¬Ý¬Ý¡G

©w¸q¦WºÙ¡e¤u§@ªí1!LineX¡f
=¤u§@ªí1!$E$2+ROW(INDIRECT(1&":"&¤u§@ªí1!$E$3-¤u§@ªí1!$E$2+1))-1
©w¸q¦WºÙ¡e¤u§@ªí1!LineY¡f
=¤u§@ªí1!LineX^2

¹Ïªí¡e¨Ó·½¸ê®Æ¡f¡G
¢æ¶b¡G=¤u§@ªí1!LineX
¢ç¶b¡G=¤u§@ªí1!LineY

Xl0000374.rar (8.9 KB)
¡@

TOP

ÁÂÁ¤j¤jªº­@¤ß´£¨Ñ¡A§Ú¦¬¨ì¤F¡AÁÂÁ±zªº¸Ñµª!!!

TOP

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

¤j¤j¡A§Ú¥i¥H¦A°Ý­Ó°ÝÃD¶Ü??
§Ú¦p¦ó³]©w¨ú¼Ë¶¡®æ¡A¨Ò¦p³Ì¤j¡B³Ì¤p¬°+-1000¡A§Ú¨C1Åã¥Ü¤@ÂI·|³y¦¨¹Ï§Î¹L²Ó¡A·|ÅܺC!!
¦³¿ìªk§ï¦¨¨C50©Î100Åã¥Ü¤@ÂI¶Ü??

TOP

¦^´_ 6# lichang


¦b¢Ô¢±¿é¤J°Ï¶¡­È¡]ª`·N¡G¥²¶·¥i¾ã°£¡^
©w¸q¦WºÙ¡e¤u§@ªí1!LineX¡f¡D§ï¬°¡G
=(¤u§@ªí1!$E$2/¤u§@ªí1!$F$2+ROW(INDIRECT(1&":"&(¤u§@ªí1!$E$3-¤u§@ªí1!$E$2)/¤u§@ªí1!$F$2+1))-1)*¤u§@ªí1!$F$2
¡@
Xl0000374_v02.rar (9.36 KB)
¡@
¡@

TOP

        ÀR«ä¦Û¦b : ¶¢¤HµL¼Ö½ì¡A¦£¤HµL¬O«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD