不重複 二欄規定優先次序 (13191)

D2=IFERROR(INDIRECT(TEXT(SUM(ABS({100,0}-MID(MAX(IF(COUNTIF(D$1:D1,A$2:B$9)=0,{1,2}*10001+(100-ROW($2:$9))/1%)),{2,4},2))*{100,1}),"!R0C00"),),"")