按得分低至高求相邻号 (10772)


V2:X20{=IFERROR(MID(SMALL(IF($A$3:$A$20-$B$1:$S$1=1,$B$3:$S$20/1%%+$A$3:$A$20/1%+$B$1:$S$1),ROW(A1)),COLUMN(A1)*2-1,2),"")


另解{=IFERROR(MID(SMALL(IF($B$2:$S$19="",$B$3:$S$20/1%%+$B$1:$S$1+$A$3:$A$20/1%),ROW(A1)),COLUMN(A1)*2-1,2),"")


留言