- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 277
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-12-23
|
¥»©«³Ì«á¥Ñ Hsieh ©ó 2014-8-8 16:12 ½s¿è
¦^´_ 7# bridetobe
§â¸ê®Æ®wÂà¸m§@¹ï·Óªíªº§@ªk¨Ã¤£¬O¦n¤èªk
¦A»¡¨º»ò¦h©w¸q¦WºÙ·|²Ö¦º¤H(¨C¼W¼t°Ó´Nn¼W¥[¦WºÙ)
±N«~¶µ²M³æ¸ê®Æ¥HAÄæ§@±Æ§Ç
§â²Ä3Ó¤u§@ªí±Ë±ó¡A«Ø¥ß¥H¤U4Ó¦WºÙ
a=OFFSET(«~¶µ²M³æ!$A$2,,,COUNTA(«~¶µ²M³æ!$A:$A)-1,)
s=COUNTA(a)
x=OFFSET(«~¶µ²M³æ!$B$1,MATCH(±ÄÁÊ©ú²Ó!$E2,«~¶µ²M³æ!$A:$A,0)-1,,COUNTIF(«~¶µ²M³æ!$A:$A,±ÄÁÊ©ú²Ó!$E2),)
¼t°Ó¦W=OFFSET(«~¶µ²M³æ!$H$2,,,65536-COUNTBLANK(«~¶µ²M³æ!$H:$H)-1,)
ª½±µ¦b«~¶µ²M³æ¤u§@ªíH2¿é¤J°}¦C¤½¦¡
=IF(ROW(±ÄÁÊ©ú²Ó!A1)>SUM(1/COUNTIF(a,a)),"",INDEX(a,SMALL(IF(COUNTIF(OFFSET(INDEX(a,1,1),,,ROW(INDIRECT("A1:A"&s)),),a)=1,ROW(INDIRECT("A1:A"&s)),""),ROW(±ÄÁÊ©ú²Ó!A1))))
¤U©Ô¦Ü¥X²{ªÅ¥Õ
±ÄÁÊ©ú²ÓEÄæÅçÃÒ
=¼t°Ó¦W
±ÄÁÊ©ú²ÓFÄæÅçÃÒ
=x
±ÄÁʪí³æ.zip (27.09 KB)
|
|