ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¦p¦ó¨ú±o°Ï°ì¤º©Ò¥X²{ªº¼Æ¦r

¦p¦ó¨ú±o°Ï°ì¤º©Ò¥X²{ªº¼Æ¦r

½Ð°Ý
¦p¦ó¨ú±o°Ï°ì¤º(A2: KW214)©Ò¥X²{ªº¼Æ¦r
PC3K2000-01.zip (175.38 KB)

EB11=1
KY2=COUNT(A2:KW2)

TOP

¦^´_ 2# hcm19522
§Ú¬O·Q¦b³o½d³ò¤º, ·|¥X²{ "0", "1", "3 ", "41", "42" ªº¼Æ¦r
¦Ó¤£¬O¦¸¼Æ

TOP

¦^´_ 3# dragonhsu

LA2{=TEXT(MIN(IF((COUNTIF(LA$1:LA1,A$2:KW$214)=0)*(A$2:KW$214<>"")*ISNUMBER(-A$2:KW$214),A$2:KW$214,99)),"[=99]! ")

TOP

ÁÂÁ°եi¥H§ä¥X 0,1,3,41,42 ¤F¦ý¬O¦n¹³«Ü¦Y¨t²Î¸ê·½.

TOP

¦^´_ 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¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¶¢¤HµL¼Ö½ì¡A¦£¤HµL¬O«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD