住址依規定排序 (15047)

D2:E21{=INDEX(A:A,RIGHT(SMALL(RIGHT(SMALL(IF(1-ISERR(FIND({"号","街","一巷","二巷","三巷"},$A$2:$A$21)),{1,2,3,4,5})+ROW(2:21)/1%,ROW($1:$20)*5),2)/1%%+RIGHTB(LEFT($A$2:$A$21,FIND("号",$A$2:$A$21)-1),2)/1%+ROW($2:$21),ROW(A1)),2))