[µo°Ý] «ü©w¼Æ¦rÅã¥Ü¦b¤£¦PÄ檺¨ç¼Æ¤½¦¡¡C

ziv976688

½Ð¦U¦ì¤j¤jÀ°¦£!ÁÂÁÂ¥ý^^

½Ð±Ð¡JT7ªº¨ç¼Æ¤½¦¡?
T7=
«ü©w=R5ªº­È¡A¦P®É¦³Åã¥Ü¦b2­Ó´Á¼Æ¥B¤£¦PÄæ¦ì¡C
¦A¦¸·PÁÂ!

­­¤£¦PÄæ.rar (13.72 KB)

¤U¸ü¦¸¼Æ: 11

2016-5-25 22:38

hcm19522

T7=IF((IFERROR(MATCH(R$5,B7:H7,),9)<>IFERROR(MATCH(R$5,J7:P7,),8))*(COUNTIF(B7:H7,R$5)=1)*(COUNTIF(J7:P7,R$5)=1),A7,"")
J7:P105®æ¦¡¤Æ=(J7=$R$5)*COUNTIF($B7:$H7,$R$5)*(OFFSET($A7,,COLUMN(A1))<>$R$5)
B7:H105®æ¦¡¤Æ=(B7=$R$5)*COUNTIF($J7:$P7,$R$5)*(OFFSET($I7,,COLUMN(A1))<>$R$5)

ziv976688

¦^´_ 2# hcm19522

hcm¤j¤j:
ÁÂÁ±zªº¸Ñµª¡C
¦]¬°§ÚOfficeªºª©¥»¬O2003¡A¨S¦³IFERROR¨ç¼Æ¡A
¥i§_½Ð±z§ï¾A¥Î2003ª©ªº¨ç¼Æ¡C
·P®¦^^

ziv976688

¦^´_ 3# ziv976688

¸É¥R:
¦]¬°©³¦â¼Ð¥Ü¥u°µ»²§U»¡©ú¥Î¡A
©Ò¥H®æ¦¡¤Æ¤½¦¡¤£»Ý­n¡C
ÁÂÁ±z!

ziv976688

¦^´_ 2# hcm19522
hcm¤j¤j:
¦]¬°¬Ý¤F±zªº¤½¦¡«á¡A±oª¾¤½¦¡²Õ¦¨ªºÅÞ¿è¡A
±NR7¤½¦¡¦A¥[¤W¤£¦PÄ檺­­¨î¡A¶ñ¤JT7
=IF((A7<>"")*OR(R$5=OFFSET(A$6,A7,1,1,7))*OR(R$5=OFFSET(I$6,I7-1,1,1,7))*(SUMIF(OFFSET(A$6,A7,1,,7),R$5,OFFSET(I$6,I7-1,1,,7))<>R$5),A7,"")
´ú¸Õ«á¡Aµª®×¥¿½T¡C

ÁÂÁ±zªº«ü¾É¡AÅý§Úªº°ÝÃD¨M¤F¡C·P®¦^^

hcm19522

{=IF((COUNTIF(B7:H7,R$5)=1)*(COUNTIF(J7:P7,R$5)=1)*(MAX(COUNTIF(R$5,B7:H7)*COLUMN(A:G))<>MAX(COUNTIF(R$5,J7:P7)*COLUMN(A:G))),A7,"")
{=IF((COUNTIF(B7:H7,R$5)=1)*(COUNTIF(J7:P7,R$5)=1)*(MAX((B7:H7=$R$5)*COLUMN(A:G))<>MAX((J7:P7=$R$5)*COLUMN(A:G))),A7,"")

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

ziv976688

¦^´_ 6# hcm19522
hcm¤j¤j:
ÁÂÁ±z¦A¦¸§@¸Ñ«ü¾É¡C
¶Q¤½¦¡ªº´ú¸Õµª®×¥¿½T¦p»Ý¨D¡C
·P®¦^^