202201271747最小值 兌換币种 (9482)

J3=INDEX($1:$1,RIGHT(MIN(IF(T(OFFSET(B3,,{1,3,5,7}))<>"",6.5^(T(OFFSET(B3,,{1,3,5,7}))="USD")*N(OFFSET(A3,,{1,3,5,7}))/1%%+{2,4,6,8})),2))

另解 J3{=INDEX($1:$1,RIGHT(MIN(IF((C3:I3<>"")*(C$2:I$2="币种"),6.5^(C3:I3="USD")*B3:H3/1%%+COLUMN(B:H))),2))

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank