求出最大值最小值 [英] Finding the maximum of minimum values

问题描述

我想计算出每一行的A S preadsheet最低值的最大值（谷歌床单，特别是）大于0。我希望这是有道理的。我的数据是：

I would like to calculate the maximum value of the minimum values of each row in a spreadsheet (Google Sheets, specifically) that is greater than 0. I hope that makes sense. My data is:

0   6   7   8   1           
0   12  21  22  21          
0   10      18  24
0   7   9   1   17          
0   16  16  20              

所以，我想一些，将产生的ARRAYFORMULA：

So, I want an ArrayFormula of some sort that will generate:

1
12
10
1
16

其中，我可以再得到最大的。我已阅读并经历了明显的解决方案不起作用，它是：

Of which I could then get the maximum. I've read and experienced that the obvious solution doesn't work, which is:

=max(ArrayFormula(min(if(A:Z>0,A:Z,"")))

的原因是它的 ARRAYFORMULA（分（... 部分返回最小整个数据集是大于0，这里是1。如果有没有很好的解决方法，我会考虑重新安排不知何故我的数据，或计算在不同的细胞极小，但我真的希望有一个1步解决方案。

The reason being the ArrayFormula(min(... part of it returns the minimum of the whole data set that's greater than 0, which is 1 here. If there's no nice workaround, I'll consider rearranging my data somehow, or calculating minima in separate cells, but I'm really hoping for a 1-step solution.

推荐答案

在除了获得每行的最小值（允许一气呵成阵列输出），请尝试：

In addition to get the minimum value per row (allowing an array output in one go), try:

=index(ArrayFormula(transpose(query(transpose(if(A:C>0, A:C,)),"select "&join("),","min(Col"&row(indirect("A1:A"&count(A:A))))&")"))),,2)

这篇关于求出最大值最小值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！