Excel formula to find lowest value above a given number and retu the column name

خرید بک لینک

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

صفحه بندی