½Ð°Ý¦p¦ó±N¤å¦rÂনȡA¨Ã±Æ§Ç?
- ©«¤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
|
¦^´_ 1# gaishutsusuru
=SMALL(VALUE(A$2:A$6),ROW(A1))
°}¦C¤½¦¡¡An¥Î ¤TÁä¿é¤J¤½¦¡(¥ý«öCTRL+SHIFT¤£©ñ¦A«öENTER¿é¤J) |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 1364
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1374
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-5-7
|
{=INDEX(A:A,RIGHT(SMALL(A$2:A$6/1%+ROW(A$2:A$6),ROW(A1)),2)) |
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|