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

[µo°Ý] ´Æ¤âªº®æ¦¡¤Æ°ÝÃD¡A¦A³Â·Ð¤j¤j¦h«ü±Ð

[µo°Ý] ´Æ¤âªº®æ¦¡¤Æ°ÝÃD¡A¦A³Â·Ð¤j¤j¦h«ü±Ð

°ÝÃD¡G

¨C6Ä欰1²Õ¡A°µ¤ñ¸û¡C¦pªþÀÉ¡A¦p¦³»¡©ú¤£²M¡A½Ð¨£½Ì¡C·Ð½Ð­Ó¦ì¥ý¶i¦h«ü±Ð¡Aµo°Ý¬O¾Ç²ßªºÃöÁä¡C

1.¨C6Ä欰1²Õ¡A§â¤j¾Ç¤ÎºÓ¤hwidth¤£¤@¼Ëªº¼Æ¦r¼Ð¤WÃC¦â
2.¨C6Ä欰1²Õ¡A§ä¥X¤j¾Ç¤ÎºÓ¤h¯Ê¤ÖªºÅܶµ


®æ¦¡¤Æ°ÝÃD.rar (20.04 KB)

¦^´_ 1# jj369963


    ½T»{¬Ý¬Ý¬O¤£¬O³o¼Ë?
®æ¦¡¤Æ°ÝÃD.rar (22.81 KB)
boyao

TOP

¦^´_ 2# boyao


ª½±µ¼g¦b¤@­Ó¦¡¤l¡A®M¥Î¨ì¾ã­Ó¤u§@ªí
A3³]©w®æ¦¡¤Æ±ø¥ó¡G
=CHOOSE(MOD(COLUMN(A3),6)+1,A3<>IT3,IF(A3="",0,COUNTIF(D$3:D$100,A3)=0),0,A3<>D3,IF(A3="",0,COUNTIF(IT$3:IT$100,A3)=0),0)

(¤£¤Ó½T©w"2.¨C6Ä欰1²Õ¡A§ä¥X¤j¾Ç¤ÎºÓ¤h¯Ê¤ÖªºÅܶµ"ªº·N«ä¡A´N·Ó¼Ó¤WªºÅÞ¿è¨Ó¼g)

®æ¦¡¤Æ°ÝÃD_sol.rar (22.88 KB)

TOP

¦^´_ 3# Bodhidharma

¦^ÂФj¤j¡G
ÁÂÁ±zªº¦^À³¡A¤£¹L¨Ï¥Î¤½¦¡¼Ð¥Ü¥X¨ÓªºÃC¦â¦ü¥G¦³¨Ç°ÝÃD¡A

AÄæ»PDÄæ³£¦³@2Q2.3.text¡Awidth¤]³£¬O1000¡C¤£¹L«o³Q¼Ð°OÃC¦â¡C

¦A³Â·Ð¤j¤j¦^À³«ü±Ð¡A·P¿E

TOP

¦^´_ 4# jj369963


A59¬O@2Q2.3.text¡AD58¤]¬O@2Q2.3.text
¦ý¬Owidth§Ú¤ñªº¬OC58(11)©MF58(1000)¡A¨âªÌ¤£¦P¡A©Ò¥H¦³¼Ð¦â
¥tC59(1000)©MF59(11)¨âªÌ¤]¤£¦P¡A©Ò¦³¼Ð¦â

©Ò¥H§A­n¤ñªº¬O¤°»ò¡H¤j¾Ç©MºÓ¤h¡u¦PÅܶµªº¶µ¥Ø¡v ¡A¨äwidth¬O§_¬Û¦P¡H

TOP

¦^´_ 5# Bodhidharma


Dear:
ÁÂÁ¤j¤jªº¦^À³¡A«Ü©êºp§ÚªºÃD·N¤£²M¡C³y¦¨§xÂZ¯u©êºp

¬Oªº¡C§Ú­n¤ñ¸û ¤j¾Ç©MºÓ¤h¡u¦PÅܶµªº¶µ¥Ø¡v ¡A¨äwidth¬O§_¬Û¦P(­u¦Pªº¦a¤è¼Ð¤WÃC¦â)¡H
¥H¤Î§ä¥X¤j¾Ç¤ÎºÓ¤hÀ³¸Ó¦³¬Û¦P¤@­PªºÅܶµ(¦ì¸m¤£¦P¦C¨SÃö«Y)¡A©Ò¥H­n§ä¥X¤j¾Ç¤ÎºÓ¤h¯Ê¤ÖªºÅܶµ¡C(¨C6Ä欰¤@²Õ¨Ó°µ¹ï·Ó)

A59¬O@2Q2.3.text¡AD58¤]¬O@2Q2.3.text
¦ý¬OwidthÀ³¸Ó¤ñªº¬OC59(1000)©MF58(1000)¡A¨âªÌ¬Û¦P¡A©Ò¥H¤£¥Î¼Ð¦â
[email protected]ÉO[email protected] ¥tC58(11)©MF59(11)¨âªÌ¬Û¦P¡A©Ò¥H¤£¥Î¼Ð¦â

ÁÂÁ¤j¤jªº¥Î¤ß¦^µª

¦A³Â·Ð¤j¤j¶O¤ß«ü±Ð

TOP

¦^´_ 6# jj369963

A3³]©w®æ¦¡¤Æ±ø¥ó¡G
=CHOOSE(MOD(COLUMN(A3),6)+1,A3<>index(IT:IT,match(IU3,IR:IR,0)),IF(A3="",0,COUNTIF(D$3:D$100,A3)=0),0,A3<>index(D:D,match(IU3,B:B,0)),IF(A3="",0,COUNTIF(IT$3:IT$100,A3)=0),0)
°ò¥»¤W§A³o­Ó¸ê®Æ¨S¦³¤£¦Pªº¦a¤è
®æ¦¡¤Æ°ÝÃD_sol.rar (22.97 KB)

TOP

Dear¤j¤j:
  ¤Ó·PÁ±z¤F¡A½T¹ê¦¨¥\¡C
¦]¬°¤W­±ªº¨Ò¤l¦³ÂI²¤Æ¡A¥Î¦b¥t¥~¤@­ÓÀÉ®×(¨ä¹ê¦³¦n¦hÀÉ®×)¡A¼Ð¥ÜÃC¦â¦ü¥G¤S¦³ÂI°ÝÃD ®æ¦¡¤Æ2.rar (40.84 KB)
¥i§_¦A³Â·Ð±zÀ°§Ú¬Ý¤@­ÓÀɮשO¡H¦]¬°®M¥Î¦b³o¤@­ÓÀɮסA¦ü¥G©Ç©Çªº¡C

¦A³Â·Ð¦^À³«ü±Ð¡A·P¿E



TOP

¦^´_ 8# jj369963

§A³o­Ó¸ê®Æ¨S¦³¤W­Ó¸ê®Æªº²Ä¤G¦C¡A©Ò¥H¾ã­Ó³£­n±qA2¶}©l
¥t¥~¤W­Ó¸ê®Æ§Ú¬O°²³]§A¸ê®Æ¥u¦³100¦C¥H¤º¡A¦ý¬O§A³o­Ó¸ê®Æ§ó¦h¡A©Ò¥Hcountif¨ç¼Æ¤º­n¼W¥[(§Ú¬O°²³]§A¸ê®Æ¨ì1000µ§)
A2³]©w®æ¦¡¤Æ±ø¥ó¡G
=CHOOSE(MOD(COLUMN(A2),6)+1,A2<>INDEX(IT:IT,MATCH(IU2,IR:IR,0)),IF(A2="",0,COUNTIF(D$2:D$1000,A2)=0),0,A2<>INDEX(D:D,MATCH(IU2,B:B,0)),IF(A2="",0,COUNTIF(IT$2:IT$1000,A2)=0),0)
(¬O»¡¦pªG§A¬Ý±oÀ´¤W­±³o­Ó¤½¦¡ªº¸Ü¡AÀ³¸Ó¬O¦³¯à¤O¦Û¤vµo²{°ÝÃD¦b­þ¤~¹ï¡K¡K)

®æ¦¡¤Æ2_sol.rar (43.33 KB)

TOP

¦^´_ 9# Bodhidharma

Dear¤j¤j:

ÁÂÁ±z½T¹ê¦¨¥\¤F¡A¯u¬O¤£¤~¡A½T¹ê¬Ý¤£À´¤½¦¡¡AÁÙ¦b¬ã¨s¤¤

=CHOOSE(MOD(COLUMN(A3),6)+1,A3<>index(IT:IT,match(IU3,IR:IR,0)),IF(A3="",0,COUNTIF(D$3:D$100,A3)=0),0,A3<>index(D:D,match(IU3,B:B,0)),IF(A3="",0,COUNTIF(IT$3:IT$100,A3)=0),0)

¦pªG¤j¤jÄ@·N¼ö¤ß¸Ñ»¡¡A·|«Ü°ª¿³¡A¦]¬°¬Ý¤F«Ü¤[ÁÙ¬O¨S²z¥XÀYºü(mod¬O¨D¾l¼Æ¡Aı±o¤j¤j¥Îªº¤Ó¶i¶¥¤F)

¥t¥~¤]«Ü·P¿E±zªº«ü±Ð¡A¦A¦¸ÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD