¦p¦ó¦Û°Ê²Îp©Ê§O¦~ÄÖ¼h¤H¼Æ?
- ©«¤l
- 15
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 20
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-9-3
- ³Ì«áµn¿ý
- 2016-2-19
|
¦p¦ó¦Û°Ê²Îp©Ê§O¦~ÄÖ¼h¤H¼Æ?
©Ê§O¦~ÄÖ¼h²Îpªí.rar (9.14 KB)
¦b¤@¥÷¦W¥U¤¤¦p¦ó¦Û°Êpºâ©Ê§O¤Î¦U¦~ÄÖ¼h¤HûӼơA¤p§Ì·Q¯}¸£³U·Q¤£¥X¨Ó¡A½Ð±Ð¦U¦ì¢Ó¢æ¢Ñ¢Ó¢Ú¥ý¶i¦³¦óºØ¨ç¼Æ¥i¸Ñ¨M¡AÁÂÁ¡C |
|
|
|
|
|
|
- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 184
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-8-20
![2023¦~¥þ¶Ô¼ú³¹ 2023¦~¥þ¶Ô¼ú³¹](images/common/2023.png) ![2022ªê¦~¥þ¶Ô¼ú³¹ 2022ªê¦~¥þ¶Ô¼ú³¹](images/common/hu.gif) ![2021¤û¦~¥þ¶Ô¼ú³¹ 2021¤û¦~¥þ¶Ô¼ú³¹](images/common/niu.gif) ![2020¹«¦~¥þ¶Ô¼ú³¹ 2020¹«¦~¥þ¶Ô¼ú³¹](images/common/shu.gif) ![2019 ½Þ¦~¥þ¶Ô¼ú³¹ 2019 ½Þ¦~¥þ¶Ô¼ú³¹](images/common/zhu.gif) ![2018 ª¯¦~¥þ¶Ô¼ú³¹ 2018 ª¯¦~¥þ¶Ô¼ú³¹](images/common/gou.gif) ![2017 Âû¦~¥þ¶Ô¼ú³¹ 2017 Âû¦~¥þ¶Ô¼ú³¹](images/common/ji.gif) ![2016µU¦~¥þ¶Ô¼ú³¹ 2016µU¦~¥þ¶Ô¼ú³¹](images/common/hou.gif) ![2015¦Ï¦~¥þ¶Ô¼ú³¹ 2015¦Ï¦~¥þ¶Ô¼ú³¹](images/common/yang.gif) ![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2013³D¦~¥þ¶Ô¼ú³¹ 2013³D¦~¥þ¶Ô¼ú³¹](images/common/she.gif) ![2012Às¦~¥þ¶Ô¼ú³¹ 2012Às¦~¥þ¶Ô¼ú³¹](images/common/long.gif) ![½×¾Â°^Äm¾±³¹ ½×¾Â°^Äm¾±³¹](images/common/medal5.gif) ![¼ö¤ß¤½¯q¾±³¹ ¼ö¤ß¤½¯q¾±³¹](images/common/medal15.gif) ![2011¨ß¦~¥þ¶Ô¼ú³¹ 2011¨ß¦~¥þ¶Ô¼ú³¹](images/common/tu.gif)
|
¦^´_ 1# wenwu748
K3=SUMPRODUCT(($B$2:$B$16=$J3)*($A$2:$A$16=$I3)*($D$2:$D$16=K$2)*(LOOKUP(INT((TEXT(TODAY(),"e")-$E$2:$E$16+1)/10),{0,2,3,4,5,6,7,8,9})=INT((COLUMN(A1)+3)/2)))
¦V¥k¦V¤U½Æ»s |
|
¾Ç®üµL²P_¤£®¢¤U°Ý
|
|
|
|
|
- ©«¤l
- 15
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 20
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-9-3
- ³Ì«áµn¿ý
- 2016-2-19
|
ÁÂÁ¶W¯Åª©¥Dªº¦^µª
¤£¹L¦n¹³§Úªºªíµª¦³°ÝÃDJ15ªº¾F¼Æ15¬OÂЮ֥Τ£¬O¥Î¨Ó§ä²Ä15¾Fªº©Ê§O¤Î¦~ÄÖ¼hӼơA§Únªº¬Opºâ¨½ªº©Ê§O¤Î¦U¦~ÄÖ¼h¤HûӼơA¥i§_¦AÀ°¦£×§ï¤@¤U¡AÁÂÁ¶W¯Åª©¥D |
|
|
|
|
|
|
- ©«¤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
![½×¾Â°^Äm¾±³¹ ½×¾Â°^Äm¾±³¹](images/common/medal5.gif)
|
K3=SUMPRODUCT(($D$2:$D$16=K$2)*($E$2:$E$16>=((INT((COLUMN(A1)+1)/2)+1)*10))*($E$2:$E$16<(((INT((COLUMN(C1)+1)/2))+1)*10))*1) |
|
|
|
|
|
|
- ©«¤l
- 15
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 20
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-9-3
- ³Ì«áµn¿ý
- 2016-2-19
|
ÁÂÁÂANGELAª©¥Dªº¸Ñµª¨ü¥ÎµL½a |
|
|
|
|
|
|
- ©«¤l
- 11
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 25
- ÂI¦W
- 0
- §@·~¨t²Î
- windows7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-10-22
- ³Ì«áµn¿ý
- 2012-12-13
|
³Ìªñ¤]¸I¨ì³o¼ËªºÃøÃD¡A¤£¹L²ÎpªºªF¦è¤£¦P¡A§Ú·QÀ³¸Ó¤è¦¡¬O¤@¼Ëªº¡C |
|
|
|
|
|
|