- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2016-6-2 09:14 ½s¿è
¦^´_ 1# lichang
¤@¡B©w¸q¦WºÙ
1¡B¡u¦WºÙ¡v¿é¤J rng¡A¡u°Ñ·Ó¨ì¡v¿é¤J=OFFSET(¤u§@ªí1!$H$2,,,COUNTA(¤u§@ªí1!$H:$H)-1)
2¡B¡u¦WºÙ¡v¿é¤J x¡A¡u°Ñ·Ó¨ì¡v¿é¤J=MATCH(¤u§@ªí1!$A2,rng,0)
3¡B¡u¦WºÙ¡v¿é¤J I¡A¡u°Ñ·Ó¨ì¡v¿é¤J=INDIRECT(ADDRESS(x+1,COLUMN(¤u§@ªí1!$I$1)))
4¡B¡u¦WºÙ¡v¿é¤J J¡A¡u°Ñ·Ó¨ì¡v¿é¤J=INDIRECT(ADDRESS(x+1,COLUMN(¤u§@ªí1!$J$1)))
5¡B¡u¦WºÙ¡v¿é¤J K¡A¡u°Ñ·Ó¨ì¡v¿é¤J=INDIRECT(ADDRESS(x+1,COLUMN(¤u§@ªí1!$K$1)))
6¡B¡u¦WºÙ¡v¿é¤J L¡A¡u°Ñ·Ó¨ì¡v¿é¤J=INDIRECT(ADDRESS(x+1,COLUMN(¤u§@ªí1!$L$1)))
¤G¡BÀx¦s®æF2¿é¤J¤½¦¡
=IFERROR(IF(SUMPRODUCT((B2=I)*(C2=J)*(D2=K)*(E2=L))<>1,"NG","OK"),"NG")
¦V¤U½Æ»s¤½¦¡
¥H¤W©å¨£¡A½Ð°Ñ¦Ò¡I |
|