- ©«¤l
- 617
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 662
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-3-7
|
¦^´_ 1# a6566
1¡B·s¼W»²§UÄæ
(1) KÄæ¡AÀx¦s®æK1¿é¤J¤½¦¡ =INDIRECT(ADDRESS(ROW(1:1),ROW(1:1)))¡A¦V¤U½Æ»s¤½¦¡¡C
(2) LÄæ¡AÀx¦s®æL1¿é¤J°}¦C¤½¦¡ =SMALL(IF(COUNTIF($K$1:$K$9,{0,1,2,3,4,5,6,7,8,9}),99,{0,1,2,3,4,5,6,7,8,9}),ROW(1:1))¡A¦V¤U½Æ»s¤½¦¡¡C
°}¦C¤½¦¡½Ð¥H Ctrl+Shift+Enter ¤TÁä»ô«ö¿é¤J
2¡BÀx¦s®æJ1¿é¤J¤½¦¡ =TRIM(SUBSTITUTE(CONCATENATE(L1," ",L2," ",L3," ",L4," ",L5," ",L6," ",L7," ",L8," ",L9),99,""))
¥H¤W©å¨£¡A½Ð°Ñ¦Ò¡I |
-
-
fig.jpg
(124.22 KB)
|