[µo°Ý] ­«½ÆÄæ¦ì§R°£+²Ä2Äæ§PÂ_

dabus

¤j®a¦n
¤p§Ì¬O¤u¼t¥Í²£ºÞ²z¤H­û,¥Ñ¤u§@»Ý­n¾ã¸Ì¤j¶q¼Æ¾Ú, ©Ò¥H­n½Ð±Ð¤j®aVBA¯à§_°µ¨ì¥H¤U¥\¯à
¥Ø«e¬O±Ä¥Î¤â°Ê¼Ð¥Ü­«½ÆÃC¦â«á¦A¥Ñ¤H¤u§PÂ_BÄæ¦r¦ê©Î¼Æ¦r¦A§R°£­«½Æªº¤@¾ã¦C,¥Ñ©ó³o¼Ë
¤è¦¡¹J¨ì¤j¶q¸ê®Æ«Ü¯Ó®É¤]®e©ö¥X¿ù,©Ò¥H¨Ó½Ð±Ð¦U¤j°ª¤â¬O§_¯à¥ÎVBA°µ¨ì¥H¤U´XÂI­n¨D

1.§ä¨ìªºAÄæ­«½Æ¼Æ¦r«á§PÂ_BÄæ¦pªG­«½Æªº2­ÓÄæ¦ì³£¬O¤@¼Ë(PASS ©Î FAIL)«h¥u»Ý¯d¤U¤@¦C(§R°£)
2.§ä¨ìªºAÄæ­«½Æ¼Æ¦r«á§PÂ_BÄæ¦pªGBÄæ2­ÓÄæ¦ì¦r¦ê¤£¦P(PASS ©Î FAIL)«h¥u»Ý¯d¤UPASS¨º¤@¦C

¥¼§¹¦¨

¤U¸ü (120.73 KB)
¥¼§¹¦¨¹Ï

2016-5-28 09:53

§¹¦¨

¤U¸ü (65.71 KB)
§¹¦¨«á¹Ï

2016-5-28 09:59

ªþ¥ó
Book13.zip (59.1 KB)

¤å¥óÀÉ
¤U¸ü¦¸¼Æ: 3

2016-5-28 09:55

ML089

¦^´_ 1# dabus

AÄ榳±Æ§Ç¡ABÄæ PASS³£¦b²Ä¤@¦C®É
J2 =IF(A2=A1,"DEL","")
¤U©Ô

¦Û°Ê¿z¿ï JÄæ - DLE¡A¿ï¨ú§R°£

hcm19522

¦^´_ 4# dabus

dabus

¦^´_ 3# hcm19522


   ©êºp¬Ý¤£¤ÓÀ´,½Ð°Ý³o¸Õ¦Û¤v±a¤½¦¡¶Ü?

hcm19522

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

E2:E16=IF(COUNTIF(B$2:B2,B2)=1,ROW(),"")
F2:F16=IFERROR(INDEX(B:B,SMALL(E$2:E$16,ROW(A1))),"")
G2:G16{=IF(F2="","",IF(ISNA(MATCH("PASS",IF(B$2:B$16=F2,C$2:C$16),)),"FAIL","PASS"))
(µL»²§U)I2:I16{=INDEX(B:B,MIN(IF((COUNTIF(I$1:I1,B$2:B$999)=0)*(B$2:B$999<>""),ROW(B$2:B$999),4^8)))&""
J2:J16{=IF(I2="","",IF(ISNA(MATCH("PASS",IF(B$2:B$16=I2,C$2:C$16),)),"FAIL","PASS"))
K2:K16=IF(I2="","",INDEX(C:C,MATCH(I2&J2,A$2:A$999&B$2:B$999,)+1))

hcm19522

J2=IF(COUNTIF(A$2:A2,A2)=1,ROW(),"")
K2=IFERROR(INDEX(A:A,SMALL(J$2:J$999,ROW(A1))),"")
L2{=IF(K2="","",IF(ISNA(MATCH("PASS",IF(A$2:A$999=K2,B$2:B$999),)),"FAIL","PASS"))