¦p¦ó¨ú±o°Ï°ì¤º©Ò¥X²{ªº¼Æ¦r
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 5# dragonhsu
À³¸Ó¬O COUNTIF(LA$1:LA1,A$2:KW$214) ³oÓ·|¦û«Ü¦h¸ê·½
¸Õ¸Õ¤U¦¡
LC2 =IFERROR(SMALL(A$2:KW$21,COUNTIF(A$2:KW$21,"<="&MAX(-1,LC$1:LC1))+1),"") |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|