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

[µo°Ý] ¿ï¨ú¤j©ó¬Y¼Æªº­È

¦^´_ 6# ziv976688


=IF(MAX($A5:A5)=MAX(1:1),"",SMALL(1:1,COUNTIF(1:1,"<="&MAX(8,A5))+1))

TOP

¦^´_ 12# papaya

°}¦C:
=IF(COUNTIF(1:1,"<=8")=COUNTIF(1:1,"<"&MIN($A7:A7)),"",MAX(IF($B1:$AX1<--TEXT(A7&"","0;;;!9!e!9"),$B1:$AX1)))

TOP

        ÀR«ä¦Û¦b : ¤£­nÀH¤ß©Ò±ý¡A­nÀH¤ß±Ð¨|¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD