指定姓名放第一 其餘依序 (13638)

D2:G9{=INDEX($B:$B,100-MOD(LARGE(($B$2:$B$9=D$1)/1%-ROW($2:$9),ROW(A1)),100))

I2:L9{=INDEX($B:$B,RIGHT(SMALL(-($B$2:$B$9=D$1)/1%-ROW($2:$9),ROW(A1))))