排序 有先後 同名相聚 (10371)

G2:I8{=INDEX($B:$B,RIGHT(LARGE(MMULT(1-ISERR(FIND({"华为","荣耀"},$B$2:$B$8)),{2;1})/1%%+C$2:C$8/1%+ROW($2:$8),ROW(A1)),2))

K2:O8{=INDEX(A:A,RIGHT(LARGE(MMULT(1-ISERR(FIND({"华为","荣耀"},$B$2:$B$8)),{2;1})/1%%+MMULT($C$2:$E$8,{1;1;1})/1%+ROW($2:$8),ROW(A1)),2))