½Ð±Ð«ö¨âÓ±ø¥ó³£²Å¦X§ä¨ì·j´MȪº¨ç¼Æ¼gªk
- ©«¤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
|
½Ð±Ð«ö¨âÓ±ø¥ó³£²Å¦X§ä¨ì·j´MȪº¨ç¼Æ¼gªk
:$ ¦U¦ì¥ý¶i±z̦n:
º¥ý«Ü©êºp¦]¬°¬O·s¤â
°Q½×°ÏÁö¤w¦³¬ÛÃö»¡©ú
¦ýµL¤U¸üÀÉ®×Åv¥[¤W²Â²Âªº
²z¸Ñ¤O«Ü®t
¬G¦b¦¹¤S´£¥XÃþ¦ü°ÝÃD¹ê¦b«Ü©êºp
Áٱ氪¤âÌ«üÂI¤@¤G
º¥ý¦P¨Æ«Ø¦³"¶Ç²¼¸ê®Æ"ªº¬¡¶Ã¯
¶Ç²¼¸¹½X ɤèª÷ÃB ·|p¬ì¥Ø:
20101228010 10,000 613321 ¾P°â¶O¥Î-¯²ª÷
20101231017 5,397 613321 ¾P°â¶O¥Î-¯²ª÷
20101231017 794 613321 ¾P°â¶O¥Î-¯²ª÷
20101231226 18,999 613321 ¾P°â¶O¥Î-¯²ª÷
20101231116 5,767,361 613321 ¾P°â¶O¥Î-¤ô¹q¶O
20101231116 536,100 613322 ¾P°â¶O¥Î-¤ô¹q¶O
§Úªº¤u§@»Ý«ö³¡ªù±N¶Ç²¼¿é¤JÀË®Ö
AÄæ BÄæ
1 ¶Ç²¼¸¹½X ª÷ÃB
2 20101231226 18,999
3 20101231226 727,021
4 20101231226 685,115
5 20101231044 2,000
6 20101231116 536,100
§Ú§Æ±æ¯à§Q¥Î¨ç¼Æ¦bCÄæ±o¨ì¸ê®Æ¦p¤U
AÄæ BÄæ CÄæ
¶Ç²¼¸¹½X ª÷ÃB §Æ±æ¥X²{²Å¦óA+BÄ椧·|p¬ì¥Ø
20101231226 18,999 613321 ¾P°â¶O¥Î-¯²ª÷
20101231226 727,021 µL¸Ó¶µª÷ÃB
20101231226 685,115 µL¸Ó¶µª÷ÃB
20101231044 2,000 µL¶Ç²¼¸ê®Æ
20101231116 536,100 613322 ¾P°â¶O¥Î-¤ô¹q¶O
½Ð°Ý§Ú¦bC2À³¸Ó«ç»ò¼g¨ç¼Æ¤~¹ï
·PÁ«ü¾É |
|
Ann
|
|
|
|
|
- ©«¤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
|
§Ú¬Ý¨ì«Ü¦h¬Û¦Pªº¨Ò¤l¡A´N¦b³oÓ°Q½×ª©
¦P¾Ç̦h¥b¥Îlookup¨ç¼Æ©Îsumproduct¨ç¼Æ³B²z³oÃþ°ÝÃD
«Øij§A¦h§ä§ä¡A¦h¬Ý¬Ý¡A§â½×³õªº©«¤l³£¬Ý§¹¤F¡A¦¨¤£¤F¥P¤]¦¨¦ò¤F¡I |
|
|
|
|
|
|
- ©«¤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
|
=IF(COUNTIF($A$2:$A$18,$F3),IF(COUNTIF($B$2:$B$18,$G3),LOOKUP(1,1/($A$2:$A$18&$B$2:$B$18=$F3&$G3),$C$2:$C$18),"µL¸Ó¶µª÷ÃB"),"µL¶Ç²¼¸ê®Æ") |
-
-
IF¥Îªk.jpg
(81.13 KB)
|
¨S¨Æ´N¨Ó³}³}
|
|
|
|
|
- ©«¤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
|
«Øij§A¦h§ä§ä¡A¦h¬Ý¬Ý¡A§â½×³õªº©«¤l³£¬Ý§¹¤F¡A¦¨¤£¤F¥P¤]¦¨¦ò¤F¡Ichin15 µoªí©ó 2011-3-29 08:23
½T¹ê...§Ú¤§«eÁÙ¨Sµo²{³oÓºô¯¸¤§«e¤]¬O¤@ª¾¥b¸Ñ¡A
¬Ý¤F¤@¬q®É¶¡¤§«áÁöµM¤´¬O¥b±í¤ô¡A¦ý»{ÃѪº¤u¨ã¤w¸g°÷¹B¥Î¦b¥Ø«eªº¤u§@¤W¤F~ |
|
¨S¨Æ´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
|
=IF(COUNTIF($A$2A$18,$F3),IF(COUNTIF($B$2B$18,$G3),LOOKUP(1,1/($A$2A$18&$B$2B$18=$F3&$G3),$C ...
fr447446 µoªí©ó 2011-3-29 09:05
º¥ý·PÁ±zªº«ü¾É
¨Ì±zªº´£¨Ñ¤w¸g¥i¥H¹F¨ì§Ú»Ý¨D
¹ï©ó¬Ý¤£À´°Q½×°Ï¬Û¦ü¥DÃDªº»¡©ú¤]ı±o«Ü²Û·\
¹ê¦b¬O¤u§@»Ýn¨S¦³«Ü¦h®É¶¡Åý§ÚºCºCÁA¸Ñ
¤~µwµÛÀY¥Ö°Ý
¹ï©ó°}¦CªºÆ[©À¤£¬O«ÜÀ´
¥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?
¤£½×¦p¦ó¯uªº«ÜÁÂÁ±zÄ@·N¬°§Ú¸Ñ¨M¤§«eªº°ÝÃD
ÁÂÁÂ |
|
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
|
§Ú¬Ý¨ì«Ü¦h¬Û¦Pªº¨Ò¤l¡A´N¦b³oÓ°Q½×ª©
¦P¾Ç̦h¥b¥Îlookup¨ç¼Æ©Îsumproduct¨ç¼Æ³B²z³oÃþ°ÝÃD
«Øij§A¦h§ä ...
chin15 µoªí©ó 2011-3-29 08:23
¦b°ÝÃD¤º§Ú¤]©ú¥Õ
«ü¥X¤w¦b°Q½×°Ï¬Ý¨ì¬ÛÃö¥DÃD
¥u¬O°Q½×°Ï¤WªºÀɮץثeµLÅv¤U¸ü
¥ú¬Ý°Q½×ª©¹ê¦b·Q¤£¥X¨Ó
¨ü©ó®É¶¡À£¤O
¥u¦n«Ü²Û·\¦a´£¥X°ÝÃD
³Â·Ð¦U¦ì¥ý¶i»P¤©«ü¾É
¬Û«H§Ú
¹ê¦b¬O¦³¥ý¦Û¦æ§ä¹LÃþ¦ü¥DÃD
¹ï©ó¦Û¤v·MÄøµLªkÁA¸Ñ©ú¥Õ
´£¥X«½Æ¬ÛÃö°ÝÃD
§Ú¯uªº«Ü©êºp |
|
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
|
³oӤ覡¬O¦b³oÃä¾Ç¨ìªº...¥u¬O§Úªº¸ÑÄÀ¥i¯à·|¤£²M·¡~
¦h¬Ý¤@¨Ç§O¤Hªº°ÝÃDÀ³¸Ó¥i¥H§ä¨ì¤ñ¸û©ú½Tªº¸ÑÄÀ¡A
¥H¤U´N¥H§Úªº·§©À¸ÑÄÀ¤½¦¡¡A
=LOOKUP(1,1/($A$2:$A$18&$B$2:$B$18=$F2&$G2),$C$2:$C$18)
²Ä¤@Ó¤Þ¼Æ 1¡A¥Î¨Ó§ä¨ì²Ä¤G¤Þ¼Æ¸ê®Æ¦ê¸Ì±ªº¼ÆÈ¡A¥i¥Î¤j©ó0ªº¥ô¦ó¼Æ¦r
²Ä¤GÓ¤Þ¼Æ 1/($A$2:$A$18&$B$2:$B$18=$F2&$G2)¡A±o¨ì {0,0,0,1,0,0,0,...} ³o¼Ëªº¸ê®Æ¡A
·í¦³²Å¦X²Ä¤@Ӥ޼ƪº¸ê®Æ®É¡A´N¦^¶Ç¬Û¹ïÀ³ªº²Ä¤TӤ޼ơA
¦¹¥Îªk©Ò§ä¨ìªº¬O³Ì«á¤@µ§²Å¦Xªº¸ê®Æ¡C
¤ñ¸û©ú½Tªº¸ÑÄÀ¥i¯àn½Ð¨ä¥L«e½ú¨Ó¸ÑÄÀ¤F¡A
¤§«e¦³¬Ý¹L«e½ú°µ¹L¸Ô²Óªº¸ÑÄÀ¡A¦ý...§Ñ°O¦bþ¸Ì¤F... |
|
¨S¨Æ´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
|
³oӤ覡¬O¦b³oÃä¾Ç¨ìªº...¥u¬O§Úªº¸ÑÄÀ¥i¯à·|¤£²M·¡~
¦h¬Ý¤@¨Ç§O¤Hªº°ÝÃDÀ³¸Ó¥i¥H§ä¨ì¤ñ¸û©ú½Tªº¸ÑÄÀ¡A
...
fr447446 µoªí©ó 2011-3-29 20:06
·PÁ±zªº¤£§[«ü¾É |
|
Ann
|
|
|
|
|
- ©«¤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
|
¦b°ÝÃD¤º§Ú¤]©ú¥Õ
«ü¥X¤w¦b°Q½×°Ï¬Ý¨ì¬ÛÃö¥DÃD
¥u¬O°Q½×°Ï¤WªºÀɮץثeµLÅv¤U¸ü
¥ú¬Ý°Q½×ª©¹ê¦b ...
ann µoªí©ó 2011-3-29 19:04
³o¼ËÁ¿Åý§Ú¤£¦n·N«ä°_¨Ó¤F
§Ú¤]¬O¤p¾Ç¥Í¡A¤@¼ËµLÅv¡A©¼¦¹¤¬¬Û«j¼F¤¬¬Û¾Ç²ß§a¡C |
|
|
|
|
|
|
- ©«¤l
- 135
- ¥DÃD
- 19
- ºëµØ
- 0
- ¿n¤À
- 165
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »´ä
- µù¥U®É¶¡
- 2010-12-9
- ³Ì«áµn¿ý
- 2012-8-27
|
¼Ó¤W°Q½×¦³´XÂI¤£¿ù
¦³®É¤H®a¦b¤u§@,n¤Q¸U¤õ«æ§¹¦¨,´Nª½±µ´£¨Ñµª®×¦n¤F
ÁÙ¦³¤U¸üÅv¬O¤£¬O¦³ÀË°QªºªÅ¶¡? |
|
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|