202210051456最接近今天均价 (10580)


 

I2=LOOKUP(1,0/(A$2:A$16=H2)/(MAX((A$2:A$16=H2)*C$2:C$16)=C$2:C$16),D$2:D$16)

另解=LOOKUP(1,0/(COUNTIFS(A:A,A$2:A$16,C:C,">"&C$2:C$16)=0)/(A$2:A$16=H2),D$2:D$16)

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