合併格前三名 取出 (14758)

K2{=INDEX(B:B,RIGHT(LARGE((C$2:C$31=LOOKUP("座",J$2:J2))*G$2:G$31/1%+ROW($2:$31),ROW(A1)-LOOKUP(1,0/(J$2:J2<>""),ROW($1:1))+1),2))

L2=VLOOKUP(K2,B:G,6,)

K15=OFFSET(B$1,LOOKUP(1,0/(C$2:C$31=LOOKUP("座",J$2:J2)),ROW($2:$31))-ROW(A1)+LOOKUP(1,0/(J$2:J2<>""),ROW($1:1))-1,)