½Ð±Ð«ö¨âÓ±ø¥ó³£²Å¦X§ä¨ì·j´MȪº¨ç¼Æ¼gªk
- ©«¤l
- 455
- ¥DÃD
- 8
- ºëµØ
- 1
- ¿n¤À
- 480
- ÂI¦W
- 0
- §@·~¨t²Î
- WINS home
- ³nÅ骩¥»
- OFFICE XP
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥Âí
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2015-1-22
|
¥»©«³Ì«á¥Ñ gong ©ó 2011-3-30 00:00 ½s¿è
¥i§_¦A½Ð±Ð¤@¤U¨ç¼Æ¤¤
=LOOKUP(1,1/($A$2:$A$18&$B$2:$B$18=$F2&$G2),$C$2:$C$18)
²Ä¤@Ó¤Þ¼Æ1¬O«ü?
²Ä¤GӤ޼ƪº·N«ä¬O?
n¥ýÁA¸Ñlookup¯S©Ê,
¦³±Æ°£¿ù»~¡B
¨ú1/2¦ì¸mȤñ¸û,¦p¤ñ¸ûȤñ¤¤¶¡È¤j¦A¨ú«á1/2¦ì¸mȦA¤ñ¸û,
¦p¤ñ¸ûȤñ¤¤¶¡È¤p«h¨ú«e1/2¦ì¸mȦA¤ñ¸û
¦p¦¹´`Àô,¬Glookup¦³»Ý±Æ§Ç¤§¯S©Ê
¦A»¡
1/($A$2:$A$18&$B$2:$B$18=$F2&$G2)
"1"ªº¥Øªº¬O±N"$A$2:$A$18&$B$2:$B$18=$F2&$G2"¥H¤À¼Æ¤è¦¡ªí¥Ü,¸Ó²Õ¼Æ¦p³£¤j©ó1,
¤À¼Æªí¥Ü«áÀ³¸Ó¤£·|>=1
=LOOKUP(1,1/($A$2:$A$18&$B$2:$B$18=$F2&$G2),$C$2:$C$18)
²Ä¤@Ó"1"«h¬°¯Á¤ÞÈ,
¦¹¨Ò {0,0,0,1,0,0,0,...} «hn¬Ý¹B®ð¬O§_·|§ä¨ì¨ºÓ1¤F,
§ó¥¿
¤£·|²£¥Í{0,0,0,1,0,0,0,...}
¦Ó¬O{#DIV/0!;#DIV/0!;#DIV/0!;1;#DIV/0!;#DIV/0!}
¸g±Æ°£¿ù»~Ȩú±o1 |
|
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I
|
|
|
|
|
- ©«¤l
- 455
- ¥DÃD
- 8
- ºëµØ
- 1
- ¿n¤À
- 480
- ÂI¦W
- 0
- §@·~¨t²Î
- WINS home
- ³nÅ骩¥»
- OFFICE XP
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥Âí
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2015-1-22
|
¥»©«³Ì«á¥Ñ gong ©ó 2011-3-29 23:47 ½s¿è
d12
{=IF(ISNUMBER(MATCH($B12&$C12,$A$2:$A$7&$B$2:$B$7,0)),OFFSET($C$1,MATCH($B12&$C12,$A$2:$A$7&$B$2:$B$7,0),),IF(COUNTIF($A$2:$A$7,$B12),"µL¶Ç²¼¸ê®Æ","µL¸Ó¶µª÷ÃB"))}
e12
{=IF(ISNUMBER($D12),OFFSET($D$1,MATCH($B12&$C12,$A$2:$A$7&$B$2:$B$7,0),),"")}
§ó¥¿d12
{=IF(ISNUMBER(MATCH($B12&$C12,$A$2:$A$7&$B$2:$B$7,0)),OFFSET($C$1,MATCH($B12&$C12,$A$2:$A$7&$B$2:$B$7,0),),IF(COUNTIF($A$2:$A$7,$B12),"µL¸Ó¶µª÷ÃB","µL¶Ç²¼¸ê®Æ"))}
¹Ï¤ÎÀɮצp¦³¤U¸ü½Ð¦Û¦æ§ó¥¿ |
-
-
¥¼©R¦W.JPG
(165.56 KB)
-
-
Book1.rar
(2.24 KB)
|
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I
|
|
|
|
|
- ©«¤l
- 31
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 74
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- OFFICE2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-3-29
- ³Ì«áµn¿ý
- 2014-4-10
|
¦^´_ 11# gong
·PÁª©¥Dªº»¡©ú¦³¤ñ¸ûÀ´
§Úªº°ò¦¤Ó®t
·|§ó¥[§V¤O¾Ç²ß
¯uªº«Ü·PÁ¤j®aÅý§Úªº¤u§@§Ö³t¦a¶¶§Q§¹¦¨ |
|
Ann
|
|
|
|
|
- ©«¤l
- 31
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 74
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- OFFICE2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-3-29
- ³Ì«áµn¿ý
- 2014-4-10
|
d12
{=IF(ISNUMBER(MATCH($B12&$C12,$A$2A$7&$B$2B$7,0)),OFFSET($C$1,MATCH($B12&$C12,$A$2A$7&$B$ ...
gong µoªí©ó 2011-3-29 23:30
ÁÂÁª©¥D
Åý§Ú¦³ÁŵM¶}®Ôªº·Pı
ÁöµLÅv¤U¸ü±z¬°§Ú»¡©úªºÀÉ®×
¦ý¦]¬°¬O¦Û¤vªº¸ê®Æ
ª¾¹D¸ê®Æ¤º®e
§Úªº²z¸Ñ¤£ª¾¹ï¤£¹ï
¥Dn¬O
§Q¥Îmatch±o¨ì°}¦C»P·j´MȬ۲ŦX¤§¬Û¹ï¦ì¸m
¦A¥Îoffset¨Ì¸Ó¦ì¸m¨ú±o·j´MÈ
¥t¥~´N¬O¹B¥ÎIF»PISNUMBER¥h§PÂ_<-³o¤ñ¸û®e©ö±q®Ñ»POFFICE»¡©ú²z¸Ñ
¯uªº«Ü·PÁ¤ñ§Ú¨ì®Ñµó½¬ÝN¥»®Ñ
¨Ó±o²M·¡©ú¥Õ |
|
Ann
|
|
|
|
|
- ©«¤l
- 61
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 116
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOSXP
- ³nÅ骩¥»
- OFFICE2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-10-6
- ³Ì«áµn¿ý
- 2014-3-5
|
¦^´_ 11# gong
·PÁÂ~gong ª©¤jªº¸ÑÄÀ¡A
¬Ý§¹ª©¤jªº¸ÑÄÀ«á¡A¹ïLOOKUPªº¨ç¼Æ¦³¤ñ¸û²`ªº¤F¸Ñ¤F¡A
¤§«e¥uª¾¹D«ç»ò¥Î¡A¦Ó¤£ª¾¹D³oÓ¨ç¼Æªº²[¸q¡A
¦A¦¸·PÁª©¤j¤£§[«ü¾É~ |
|
¨S¨Æ´N¨Ó³}³}
|
|
|
|
|
- ©«¤l
- 227
- ¥DÃD
- 3
- ºëµØ
- 1
- ¿n¤À
- 273
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- XP
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-3-22
- ³Ì«áµn¿ý
- 2013-1-29
|
§Úı±oÁÙ¦n
ÁöµM§Ú¤]¨S¦³Åv¤U¸ü
³ßÅw³oӽ׾´N¦³¸q°È´L¦u»P°t¦X½×¾Âªº¨î«×
ªÖ¥I¥X´N¦³¦¬Àò |
|
|
|
|
|
|
- ©«¤l
- 31
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 74
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- OFFICE2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-3-29
- ³Ì«áµn¿ý
- 2014-4-10
|
¥»©«³Ì«á¥Ñ ann ©ó 2011-3-30 11:01 ½s¿è
¼Ó¤W°Q½×¦³´XÂI¤£¿ù
¦³®É¤H®a¦b¤u§@,n¤Q¸U¤õ«æ§¹¦¨,´Nª½±µ´£¨Ñµª®×¦n¤F
ÁÙ¦³¤U¸üÅv¬O¤£¬O¦³ÀË°QªºªÅ¶¡ ...
FAlonso µoªí©ó 2011-3-29 22:58
º¥ý¯uªºÄ±±o«Ü©¯¹B§ä¨ì³Â»¶®a±Ú°Q½×°Ï
Åý§xÂZ¦Û¤vªº°ÝÃD±o¨ì°ª¤âªº«üÂI
§Ö³t¦a¸Ñ¨M
¤ß¤¤¯uªº°£¤F·PÁ´N¬O¦A·PÁÂ
¥u¬O¥i¯à¤j®aµ¥¯Å³£«Ü°ª¤F
¤£ÁA¸Ñ·s¤â±¹ïªº§x¹Ò
¦b¯u¤ß³ß·R³o¸Ìªº«e´£¤U
´£¥X¦Û¤vªº±¡§Îµ¹¤j®a°Ñ¦Ò
·s¤â¤£¯à¤U¸üÀÉ®×:<-¤w¸g¸Ñ¨M «Ü»{¦PÃÙ§U½×¾Âªº²z©À
§Ú¯à²z¸Ñ
¦ý¹ï©ó¦Û¤v´£¥Xªº°ÝÃD
§O¤Hµ¹¤©¸Ñ¨Mªº¦^À³¤]¤£¯à¤U¸ü
¦³®É¸ê®ÆY¹L©ó½ÆÂø
¥i¯à¤£®e©ö²z¸Ñ
¦b¬ãŪª©¤W¤w°Q½×¹Lªº®×¨Ò
¦]µL¤U¸üÅv
¯uªº«ÜÃø©ú¥Õ(·íµM§Ú¤ñ¸û²Â¤]¦³Ãö«Y)
¤£¬O¬G·N«Âе¹¤j®a§ä³Â·Ð
ÁÂÁª©¥D»P°ª¤â̪º@¤ß®e§Ô
§ó·PÁ¤j®aµ¹¤©ªº¨ó§U |
|
Ann
|
|
|
|
|
- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
EXCELªº¨ç¼Æ»¡©ú,ÁÙ¦³«Ü¤j¦¨ªøªºªÅ¶¡,¦³®É»¡ªº¬O¤£²M¤£·¡,¦pªG¦b½×¾Â¤W¦³¬Ý¤£À´ªº¤½¦¡.¬d¬Ý»¡©ú¬O¤@©wnªº,
¥t¥~¥i¦b½s¿è¦C¤¤¬d¬Ý,¨Ò¦p
{=IF(ISNUMBER($D12) ,OFFSET($D$1,MATCH($B12&$C12,$A$2:$A$7&$B$2:$B$7,0),),"")}
±N¨ä¤¤¤@¬q¤½¦¡¤Ï¥Õ¦A«öF9.¥i±o¨ì¨º¬q¤½¦¡ªº¹Bºâµ²ªG.¥H§Q¤F¸Ñ¸ûªøªº¤½¦¡.¬Ý§¹°O±o«öESCÁä©ñ±óקï. |
|
|
|
|
|
|
- ©«¤l
- 31
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 74
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- OFFICE2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-3-29
- ³Ì«áµn¿ý
- 2014-4-10
|
EXCELªº¨ç¼Æ»¡©ú,ÁÙ¦³«Ü¤j¦¨ªøªºªÅ¶¡,¦³®É»¡ªº¬O¤£²M¤£·¡,¦pªG¦b½×¾Â¤W¦³¬Ý¤£À´ªº¤½¦¡.¬d¬Ý»¡©ú¬O¤@©wnªº, ...
ANGELA µoªí©ó 2011-3-30 10:24
·PÁ±zªº¤À¨É
¹ï·s¤â²z¸Ñ¨ç¼Æ¥Îªk¦Ó¨¥¹ê¦b¤Ó¤è«K¤F
쥻¥u·|¶Ì¶Ì¦a¤@Ó¨ç¼Æ¤@Ó¨ç¼ÆºCºC¦a©î¸Ñ |
|
Ann
|
|
|
|
|
- ©«¤l
- 61
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 116
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOSXP
- ³nÅ骩¥»
- OFFICE2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-10-6
- ³Ì«áµn¿ý
- 2014-3-5
|
¦^´_ 18# ANGELA
¶Ì¶Ìªº¤@Ó¤@Ó©î+1...
ì¨ÓÁÙ¦³³o¼Ë¤è«Kªº¥\¯àªü...
·PÁ«ü¾É~ |
|
¨S¨Æ´N¨Ó³}³}
|
|
|
|
|