(¤w¸Ñ¨M)½Ð°Ý³oºØ·j´M¤è¦¡¦³¨ç¼Æ¥i¥H°µ¨ì¶Ü
- ©«¤l
- 586
- ¥DÃD
- 123
- ºëµØ
- 0
- ¿n¤À
- 763
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-16
- ³Ì«áµn¿ý
- 2017-3-14
|
(¤w¸Ñ¨M)½Ð°Ý³oºØ·j´M¤è¦¡¦³¨ç¼Æ¥i¥H°µ¨ì¶Ü
¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 17:11 ½s¿è
§Ún·j´M"¶Ç²¼½s¸¹"¤@¼Ë¥B"¶U¤èª÷ÃB"¤£¬°0ªº¸ê®Æ
¦pªþ¥ó±¡ªp²Å¦Xªº¸ê®Æ¬OD33
¤£ª¾¹D³o¼Ë»¡©ú¦U¦ì¬ÝªºÀ´¶Ü?
Book1.rar (2.22 KB)
|
|
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ
|
|
|
|
|
- ©«¤l
- 967
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1001
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-11-29
- ³Ì«áµn¿ý
- 2022-5-17
|
¦^´_ 1# freeffly
"¶Ç²¼½s¸¹"»P¤°»ò¤@¼Ë
"¶Ç²¼½s¸¹"¤£³£¬O¤@¼Ëªº
¨º¬O¤£¬O¥un§PÂ_"¶U¤èª÷ÃB"¤£¬°0ªº¸ê®Æ |
|
|
|
|
|
|
- ©«¤l
- 586
- ¥DÃD
- 123
- ºëµØ
- 0
- ¿n¤À
- 763
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-16
- ³Ì«áµn¿ý
- 2017-3-14
|
¦^´_ 2# register313
§Ún§ä¦P¤@¦U¶Ç²¼½s¸¹¤¤¶U¤èª÷ÃB¦³¼Æ¦rªº¬ì¥Ø
§Ú³oÃä¥u©ñ¦P¤@±i¶Ç²¼
§Ún³B²zªº¸ê®Æ¦³¦n´X±i¶Ç²¼
¤£ª¾¹D³o¼Ë»¡©úÀ´¶Ü?
·sªþ¥ó¬O¤ñ¸û¦h¸ê®Æ¡A§Ú·Qn¨ú±oªº¬O-«á±ªº¸ê®Æ
§Æ±æ¤£·|¶V»¡¶V½ÆÂø
Book2.rar (4.81 KB)
|
|
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ
|
|
|
|
|
- ©«¤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
|
¦pªG¹³½d¨Ò¥u¦³°ß¤@È¥i¥Î=LOOKUP(9.9E+307,F:F)
¦³¦hÈ
=IF(ROW(1:1)>COUNTIF(F:F,">0"),"",INDEX(F:F,SMALL(IF(($F$5:$F$33<>0)*($B$5:$B$33=$B$5),ROW($5:$33)),ROW(1:1))))
°}¦C¤½¦¡ |
|
|
|
|
|
|
- ©«¤l
- 586
- ¥DÃD
- 123
- ºëµØ
- 0
- ¿n¤À
- 763
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-16
- ³Ì«áµn¿ý
- 2017-3-14
|
¦^´_ 4# ANGELA
=INDEX(D:D,SMALL(IF(($F$5:$F$33<>0)*($B$5:$B$33=$B$5),ROW($5:$33)),ROW(1:1)))
ªO¥D§ÚÀ³¸Ó¬On³o¤@¬q´N¥i¥H
¦ý¬Oµ²ªG¥u¥X²{¤@¦U¸ò§ÚnªºÁÙ¦³¤@ÂI®t¶Z
½Ð°Ý«ç»ò§ï? |
|
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ
|
|
|
|
|
- ©«¤l
- 967
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1001
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-11-29
- ³Ì«áµn¿ý
- 2022-5-17
|
|
|
|
|
|
|
- ©«¤l
- 586
- ¥DÃD
- 123
- ºëµØ
- 0
- ¿n¤À
- 763
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-16
- ³Ì«áµn¿ý
- 2017-3-14
|
¦^´_ 6# register313
³oºØ±¡§Î¬O¤£¬O¥u¯à¹³¤j¤j³o¼Ë¤À¬q³B²z
µM«á¦A¥ÎVLOOKUP ©Î¬O OFFSET¥h³B²z§A§ì¥X¨Óªº¨º¤@¶ô¸ê®Æ? |
|
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ
|
|
|
|
|
- ©«¤l
- 967
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1001
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-11-29
- ³Ì«áµn¿ý
- 2022-5-17
|
¦^´_ 7# freeffly
¤£¥Î¤À¬q³B²z
§Ú¥u¬O§â¥þ³¡ªºÄæ¦ì³£§ì¥X¨Ó
§An¬ì¥Ø¦WºÙ ¥i¥H¥u³]©w¸ÓÄ檺¤½¦¡§Y¥i ¦UÄ椣¬Û¦C¼vÅT |
|
|
|
|
|
|
- ©«¤l
- 586
- ¥DÃD
- 123
- ºëµØ
- 0
- ¿n¤À
- 763
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-16
- ³Ì«áµn¿ý
- 2017-3-14
|
¦^´_ 8# register313
§Ú¬O·Qª½±µ¹³g5:g32¨º¼ËÅã¥Üµ²ªG
¥Ø«e§Ú·Qªº¨ìªº¤è¦¡´N¬O³o¼Ë³B²z
aaa.rar (18.26 KB)
|
|
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ
|
|
|
|
|
- ©«¤l
- 967
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1001
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-11-29
- ³Ì«áµn¿ý
- 2022-5-17
|
¥»©«³Ì«á¥Ñ register313 ©ó 2012-1-4 07:56 ½s¿è
¦^´_ 9# freeffly
1.¨Ï¥Î IF¨ç¼Æ
G5=IF(F5=0,G6,D5)
2.³]©w®æ¦¡¤Æ±ø¥ó
aaa.zip (32.83 KB)
|
|
|
|
|
|
|