本帖最后由 baksy 于 2014-2-22 14:02 编辑
07版
=IFERROR(INDEX(地区!$A$1:$A$25,LARGE(IF(OFFSET(地区!$A$5:$A$25,,MATCH($A2,地区!$A$2:$BE$2,0)-1,)>=LARGE(VALUE(OFFSET(地区!$A$5:$A$25,,MATCH($A2,地区!$A$2:$BE$2,0)-1,)),IF(COUNTA(OFFSET(地区!$A$5:$A$25,,MATCH($A2,地区!$A$2:$BE$2,0)-1,))>5,5,COUNTA(OFFSET(地区!$A$5:$A$25,,MATCH($A2,地区!$A$2:$BE$2,0)-1,)))),ROW($5:$25),""),COLUMN(A$1))),"")
03版
=INDEX(地区!$A$1:$A$25,LARGE(IF(OFFSET(地区!$A$5:$A$25,,MATCH($A2,地区!$A$2:$BE$2,0)-1,)>=LARGE(VALUE(OFFSET(地区!$A$5:$A$25,,MATCH($A2,地区!$A$2:$BE$2,0)-1,)),IF(COUNTA(OFFSET(地区!$A$5:$A$25,,MATCH($A2,地区!$A$2:$BE$2,0)-1,))>5,5,COUNTA(OFFSET(地区!$A$5:$A$25,,MATCH($A2,地区!$A$2:$BE$2,0)-1,)))),ROW($5:$25),""),COLUMN(A$1))) |