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

¬Û¦P¸ê®Æ

¬Û¦P¸ê®Æ

·s¤B¦A¦V¦U¦ì¨D±Ð¡I

½Ð°Ý¦p¦ó¥i±N¤u§@ªí¤º¡A¬Û¦P¸ê®ÆªºÀx¦s®æ¡A·|¦Û°Ê¥HÃC¦âÅã¥Ü¡H

²{±NÀɮתþ¤W¡I

¬Û¦P¸ê®Æ.rar (4.39 KB)

¥»©«³Ì«á¥Ñ zz5151353 ©ó 2010-6-28 17:16 ½s¿è
·s¤B¦A¦V¦U¦ì¨D±Ð¡I

½Ð°Ý¦p¦ó¥i±N¤u§@ªí¤º¡A¬Û¦P¸ê®ÆªºÀx¦s®æ¡A·|¦Û°Ê¥HÃC¦âÅã¥Ü¡H

²{±NÀɮתþ¤W¡I
trainee µoªí©ó 2010-6-28 12:09


¥Î·Æ¹«¥ªÁä¿ï¨ú A1:C7 °Ï°ì

±ø¥ó®æ¦¡¤Æ¤½¦¡

=COUNTIF($A:$C,A1)>1

ÃC¦â¦Û¦æ¬D¿ï

test.gif (104.14 KB)

test.gif

300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¥»©«³Ì«á¥Ñ sping ©ó 2010-6-28 15:52 ½s¿è

¦^´_ 1# trainee


   ¥Î®æ¦¡¤Æ³]©w´N¥i¥H¤F
     §A¬Ý³o­ÓÀɮײŤ£²Å¦X»Ý¨D
¬Û¦P¸ê®Æ.zip (4.19 KB)

¬Û¦P¸ê®Æ.rar (6.3 KB)

TOP

¦hÁ¨â¦ìªº«ü¾É¡I
§Ú·|¸Õ¸Õ¡I

p.s.  "sping" ¡AµLªk¥´¶}»Õ¤UªºÀɮסI

TOP

¦^´_ 4# trainee

À³¸Ó¤£·|µLªk¶}±ÒÀɮפ~¹ï
§Ú§ï©ñ¤@­ÓZIPªºÀɮקA¸Õ¬Ý¬Ý

TOP

¦^´_ 5# sping


    ±zªº2­Ó¸ê®Æ
.ZIP¤Î.RAR
³£¨S¿ìªk¶}±Ò
¦Ó¥B³£·|ÅýEXCEL¾ã­Ó·í¾÷..
¤£¦n·N«ä!!ÁÂÁÂ..

TOP

¦^´_ 3# sping


¦A¦¸¦hÁ»դUªºÀ°¦£¡I

¦ý»Õ¤UªºÀɮסA§Ú¯uªºµLªk¶}±Ò¡I

TOP

¦^´_ 2# zz5151353


·P¿E»Õ¤UªºÀ°¦£¡I¡I
§Ú¤w´x´¤»Õ¤U©Ò´£ÂIªº¤èªk¡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