候選人得票 排名 (12067)

B2:I16=RANDBETWEEN(1,999)

K2{=INDEX($1:$1,RIGHT(LARGE(MMULT(COLUMN(A:O)^0,B$2:I$16)/1%+COLUMN(B:I),ROW(A1)),2))

L2=SUMPRODUCT((B$1:I$1=K2)*B$2:I$16)



留言