- ©«¤l
- 55
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 69
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2020-12-6
- ³Ì«áµn¿ý
- 2022-1-5
|
¥»©«³Ì«á¥Ñ johnny1680 ©ó 2021-10-7 17:50 ½s¿è
B6
=IF(ISERROR(SMALL(IF($B2:$AE2>0,$B2:$AE2),COLUMN(A1))),"",IF(ISERROR(SMALL(IF($B2:$AE2="",$B2:$AE2),COLUMN(A1))),"¸É³f¤¤",SMALL(IF($B2:$AE2>0,$B2:$AE2),COLUMN(A1))))
¥u¯àÅã¥Ü4ӼƦr 1,2,3,5 ©M 4Ó"¸É³f¤¤"
½Ð°Ý : B6ªº¤½¦¡n¦p¦ó×¥¿?
¤~Åã¥Ü¥X¥¿½Tµª®×(¦pB8:AE8)¡C
ÁÂÁÂ ! |
|