| ²é¿´: 255 | »Ø¸´: 0 | |||
yxwinsyͳæ (³õÈëÎÄ̳)
|
[ÇóÖú]
ExeclÖÐÎÒÐèҪѰÕÒº¯Êý·¶Î§ÖµµÄÊý¾Ý£¬ÈçºÎÐ޸Ĺ«Ê½£¿
|
|
ÎÒʹÓõĹ«Ê½ÊÇ£ºINDEX(Sheet1!A:A,SMALL(IF(Sheet1!$B$2:$B$999<0,ROW($2:$999),4^8),ROW(A1)))&"" ÆäÖÐ999<0£¬¿ÉÒÔËÑË÷µ½Ð¡ÓÚÁãµÄº¯Êý£¬½«Õâ¸öÊýÖµ·´×ªÎª0>999£¬Ôò¿ÉÒÔËÑË÷µ½´óÓÚÁãµÄº¯Êý¡£ ÎÒÇóÖúµÄÊÇÈç¹ûÎÒÐèÒªËÑË÷60.05ÖÁ80.30µÄÊýÖµ»òÕß-60.05ÖÁ-80.30µÄÊýֵʱ£¬ÎÒÓ¦¸ÃÈçºÎÐÞ¸ÄÉÏÃæµÄ¹«Ê½£¿ |
» ²ÂÄãϲ»¶
284Çóµ÷¼Á
ÒѾÓÐ10È˻ظ´
һ־Ըɽ¶«´óѧҩѧѧ˶Çóµ÷¼Á
ÒѾÓÐ4È˻ظ´
07»¯Ñ§280·ÖÇóµ÷¼Á
ÒѾÓÐ4È˻ظ´
298-Ò»Ö¾Ô¸Öйúũҵ´óѧ-Çóµ÷¼Á
ÒѾÓÐ12È˻ظ´
Çó²ÄÁÏ£¬»·¾³×¨Òµµ÷¼Á
ÒѾÓÐ3È˻ظ´
335Çóµ÷¼Á
ÒѾÓÐ5È˻ظ´
Çóµ÷¼Á
ÒѾÓÐ7È˻ظ´
Ò»Ö¾Ô¸¼ª´ó»¯Ñ§322Çóµ÷¼Á
ÒѾÓÐ4È˻ظ´
»·¾³Ñ§Ë¶288Çóµ÷¼Á
ÒѾÓÐ8È˻ظ´
341Çóµ÷¼Á(Ò»Ö¾Ô¸ºþÄÏ´óѧ070300)
ÒѾÓÐ6È˻ظ´













»Ø¸´´ËÂ¥