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

½Ð°Ý¤½¦¡¡G§PÂ_¼Æ¦r¬O§_¬Û¦P¡B¥X²{¤F¤°»ò¼Æ¦r?

½Ð°Ý¤½¦¡¡G§PÂ_¼Æ¦r¬O§_¬Û¦P¡B¥X²{¤F¤°»ò¼Æ¦r?

16042521510538679d774020f8.jpg.thumb.jpg
2016-4-26 09:27



½Ð°Ý¤j®a¡A¦b¡u¬O§_¤£¦P¡v¡B¡u¥X²{¼Æ¦r¡vªºÄæ¦ì¤½¦¡­n¦p¦ó¼g?

¡u¬O§_¤£¦P¡v¡G
1) ¨C¦Cªº4­Ó¼Æ¦r¡A¥u­n¬Û¦Pªº¸Ü¡A¥Õ¦âÄæ¦ì´NªÅ¥Õ
¡÷¨C¦C¤£¤@©w³£·|¶ñº¡4­Ó¼Æ¦r¡A¦ý³Ì¤Ö·|¶ñº¡1­Ó¼Æ¦r
¡÷¨Ò¦p¹Ï¤ùªº«e¥|­Ó¨Ò¤l

2) ¦pªG¼Æ¦r¤£¦Pªº¸Ü¡A«h¥X²{OK
¨Ò¦p¹Ï¤ùªº²Ä¤­¡B¤»ªº¨Ò¤l


¡u¥X²{¼Æ¦r¡v¡G
1) ¸Ó¦Cªº¼Æ¦r¬Û¦P(©Î¬O¨S¦³¤£¦P)¡A«h·|Åã¥Ü¨º¦Cªº¼Æ¦r

2) ¦pªG¹³²Ä6©M7¦Cªº¼Æ¦r¬O¤£¦Pªº¡A«h·|Åã¥Ü"-"


½Ð¦U¦ì¨ó§UÄ_¶Q·Qªk¡AÁÂÁ¦U¦ì¤F¡C

F2:F13{=IF((SUM(IFERROR(MATCH(A2:D2,A2:D2,)=COLUMN(A2:D2),)*1)=1)*(COUNTA(A2:D2)>1),"","OK")
G2:G13{=IF(F2="",INDEX(2:2,MATCH(,0/(COUNTIF(A2:D2,A2:D2)>1),)),"-")
2¼Ó¤w§ï

TOP

¦^´_ 1# gaishutsusuru

E2 =IF(COUNT(0/FREQUENCY(A2:D2,A2:D2))=1,"","OK")
F2 =IF(E2="OK","-",LOOKUP(,0/A2:D2,A2:D2))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# hcm19522

¦^´_©ó¤W¤è

TOP

ÁÂÁÂhcm19522¤j¤jªº¸Ñ´b¡A
·Q½Ð°Ý±z¸É¥Rªº¨Ò¤l¸Ì¡G
5 6 7 6
¡÷³o4­Ó¼Æ¦r¤¤¡A¥X²{¤F¤£¦Pªº¼Æ¦r¡C©Ò¥H§Æ±æ¥X¨Óªºµ²ªG¬O"OK"
¡÷¦A¬Û¦P­Èªº³¡¥÷¡A¦]¬°¥X²{¤£¦Pªº¼Æ¦r¤F¡A©Ò¥H§Æ±æ¥X²{"-"

²³æ¨Ó»¡¡G
§Æ±æ¥i¥H¹F¨ì
¦b¡u¬O§_¤£¦P¡vªº³¡¥÷¡A¥u­n¦³¤@­Ó¼Æ¦r¤£¦P¡A´N¥X²{OK
¦b¡u¬Û¦P­È¡vªº³¡¥÷¡A¥u­n¦³¤£¦Pªº¼Æ¦r¥X²{¡A´N¥X²{"-"


¤£¦n·N«ä¡A¥ý«e°ÝÃD¨S¦³»¡ªº²M·¡¤@ÂI¡C

TOP

http://blog.xuite.net/hcm19522/twblog/406699762

TOP

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD