判斷各項目的範圍區間 (13064)

H2=INDEX({"LOW","OK","HIGH"},SUM(FREQUENCY(G2,VLOOKUP(F2,B:D,{2,3},)-{0.1,0})*{1;2;3}))

另解H2=LOOKUP(1,0/FREQUENCY(G2,VLOOKUP(F2,B:D,{2,3},)-{0.1,0}),{"LOW","OK","HIGH"})



留言