取數字對應名稱 (11782)

C2:C5 {=SMALL(IF(COUNTIF(C$1:C1,ROW($1:$10)-1)=0,ROW($1:$10)-1),RANDBETWEEN(1,10-ROW(A1)))

E2:E5 {=SMALL(IF(COUNTIF(E$1:E1,C$2:C$5)=0,C$2:C$5),RANDBETWEEN(1,5-ROW(A1)))

F2:F5=LOOKUP(1,0/(E2=C$2:C$5),B$2:B$5)



留言