- ©«¤l
- 26
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 61
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS7
- ³nÅ骩¥»
- OFFICE2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-6-10
- ³Ì«áµn¿ý
- 2017-12-12
|
¥»©«³Ì«á¥Ñ cubela ©ó 2014-11-6 22:34 ½s¿è
¦^´_ cubela
´£¥Ü¡G§Aªº¤½¦¡§PÂ_¬O¨Ì¾ÚA1Äæ¦ìªº¦WºÙ
»k¥ú°j¯T µoªí©ó 2014-11-6 20:56
¯T¤j~§Ú§ï¦n¤F~¥i¥H¥Î¤F
¦ý§Ú¤]¤£ª¾¹D«ç§ï¦nªº:dizzy:
§Ú¬O±N쥻ªºA4Àx¦s®æ
=IF(ROW(À³¦¬±b´ÚºÞ²zªí!2:2)>COUNTIF(À³¦¬±b´ÚºÞ²zªí!$A:$A,$A$1),"",INDEX(À³¦¬±b´ÚºÞ²zªí!A:A,SMALL(IF(À³¦¬±b´ÚºÞ²zªí!$A$3:$A$960=$A$1,ROW(À³¦¬±b´ÚºÞ²zªí!$A$3:$A$960)),ROW(À³¦¬±b´ÚºÞ²zªí!2:2))))
§ï¦¨
=IF(ROW(À³¦¬±b´ÚºÞ²zªí!1:1)>COUNTIF(À³¦¬±b´ÚºÞ²zªí!$A:$A,$A$1),"",INDEX(À³¦¬±b´ÚºÞ²zªí!A:A,SMALL(IF(À³¦¬±b´ÚºÞ²zªí!$A$3:$A$960=$A$1,ROW(À³¦¬±b´ÚºÞ²zªí!$A$3:$A$960)),ROW(À³¦¬±b´ÚºÞ²zªí!1:1))))
µM«á¦V¤U½Æ»s±Æ¦C¡A¦ý³Ì«á¤@ÓÁÙ¬OÅã¥Ü¤£¥X¨Ó¡A§Ú¦A¨Ï¥ÎCTRL+SHIFT+ENTER(°}¦C)
´N¥i¥H¤F
¤£ª¾¹D³o¼Ë¬O§_¥¿½T?
PS:§Ú¤j¦h³£¨Ï¥ÎOpenOffice Calc,¸Ì±¦¡¤l¼Æ¦r¦³®É³£·|¤£¤@¼Ë~¤£ª¾¹D¬O§_·|¼vÅT¨ì)
(½Æ¥»)À³¦¬±b´ÚºÞ²zªí.rar (30.82 KB)
|
|