Excel：查找第二列确定的第一个最小值 [英] Excel: Find first lowest value in range determined by a second column

问题描述

我有两个栏目，一个是日期，另一个是无法在该日期举行的活动的人数。日期被格式化为excel日期。我想找到最少人数不能在当前日期之后的第一个日期。理想情况下，我想解决问题而不诉诸于VBA宏。

解决方案

给定列A =日期，B = people
添加第三个列：

  = IF（A1> TODAY（），B1，）
  

然后使用查找找到最小条目的日期：

  = INDEX（A：A，MATCH（MIN（C：C），C：C，0））
  / pre> 
 
 
 使用Barrys修复更新（谢谢！） 
 
I have two columns, one for the date and one for the number of people who cannot make it to an event on that date. The date is formatted as an excel date. I would like to find the first date to which the least number of people cannot make it AFTER the current date. Ideally I'd like to solve the problem without resorting to VBA macros.
解决方案
Given column A=Dates, B=Number of people
Add a third collumn with:
=IF(A1>TODAY(),B1,"")
Then use a Lookup to find the date of the smallest entry:
=INDEX(A:A,MATCH(MIN(C:C),C:C,0))
Updated with Barrys fix (thanks!)

                        
这篇关于Excel：查找第二列确定的第一个最小值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！