½Ð±Ð«ö¨âÓ±ø¥ó³£²Å¦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
|
=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
- 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
- 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
- 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 |
|
|
|
|
|
|