I'm trying to write an Excel formula that will look at 5 columns of data (for example, labeled SEL1, SEL2, SEL3, SEL4, and SEL5) and retu the column name of the lowest column with a value above a 0.80.
For example,
SEL1 SEL2 SEL3 SEL4 SEL5
0.68 0.81 0.84 0.92 0.95
In this case, I'd want it to identify SEL2.
So far I have =INDEX(A$1:E$1,MATCH(MIN(A2:E2),A2:E2,0)) - it's retuing SEL 1 because it's only looking at the minimum, not the minimum above a 0.80
Recent Questions...
ما را در سایت Recent Questions دنبال میکنید
برچسب:
نویسنده: استخدام کار
بازدید: 201
تاريخ: يکشنبه
2 خرداد
1395 ساعت: 3:43