- ©«¤l
- 678
- ¥DÃD
- 147
- ºëµØ
- 0
- ¿n¤À
- 799
- ÂI¦W
- 0
- §@·~¨t²Î
- win 8
- ³nÅ骩¥»
- MS 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-2-9
- ³Ì«áµn¿ý
- 2022-1-20
|
¥»©«³Ì«á¥Ñ ziv976688 ©ó 2020-4-30 01:36 ½s¿è
¦^´_ 4# hcm19522
ìB2¤½¦¡+«½ÆªºÈ¥u¦C1Ó.rar (2.89 KB)
h¤j¤j : ±z¦n!
=IF(ISERROR(SMALL(IF($B1:$AX1>8,$B1:$AX1),COLUMN(A1))),"",SMALL(IF($B1:$AX1>8,$B1:$AX1),COLUMN(A1)))
¤W¦CªºìB2°}¦C¤½¦¡¬O±z½ç±Ðªº¨ú±o²Ä1¦C¤j©ó¬Y¼Æ(EX:8)ªºÈ+±Æ§Ç
¦pªG¤W¦CªºB2n¦A¥[¤W"«½ÆªÌ¥u¦C¥X1Ó"ªº»Ý¨D
½Ð±Ð¡JB2ªºExcel 2003ª©¤½¦¡n¦p¦ó¦A½s¼g¡H
ÁÂÁ±z^^ |
|