取數量 重複顯現 (14988)

H3=IF(ROW(A2)-LOOKUP(1,0/(E$3:E3<>""),ROW($1:1))>VLOOKUP(LOOKUP("嫻",E$3:E3),B:C,2,),"",LOOKUP("嫻",E$3:E3))

另解=REPT(LOOKUP("嫻",E$3:E3),COUNTIF(H$2:H2,LOOKUP("嫻",E$3:E3))<VLOOKUP(LOOKUP("嫻",E$3:E3),B:C,2,))