每日跳格價錢最高 顯示 (14871)

C4:AB12格式化=(SUMPRODUCT(COUNTIF(OFFSET($C4,,FLOOR(COLUMN(A1)-1,9)+INT((COLUMN($A:$I)-1)/2)*2),">"&C4))=0)*(C$3=$C$3)

另解=(SUMPRODUCT(N(N(OFFSET($C4,,FLOOR(COLUMN(A1)-1,9)+INT((COLUMN($A:$I)-1)/2)*2))>C4))=0)*(C$3=$C$3)