合併格 各自排序 (14819)

D2=SUMPRODUCT((LOOKUP(ROW(1:15),ROW(1:15)/(B$2:B$16<>""),B$2:B$16)=LOOKUP("z",B$2:B2))*(C$2:C$16>C2))+1



留言