數字單位 取最大與最小值 (Numeric unit: take the maximum and minimum values) (11900)

E2:E3{=INDEX(PERCENTILE(SUBSTITUTE(B$1:B$15,"min",)*1,{1,0})&" min",ROW(A1))

F2:F3{=INDEX(PERCENTILE(LEFT(B$1:B$15,FIND("min",B$1:B$15)-1)*1,{1,0})&" min",ROW(A1))



留言