Excel公式位置的最小值 [英] Excel formula position of minimum value
问题描述
什么是正确的excel公式这样做吗?谢谢 。
解决方案:感谢大家的帮助,我不认为如果不连续,excel可以做。我最终使用了一系列嵌套的IF语句,AND语句和<标志,完成工作:)
这是一个应该有效的数组公式。它假定值在A1,C3和B4中。
= MAX(IF(CHOOSE(TRANSPOSE({1,2,3} ),$ A $ 1,$ C $ 3,$ B $ 4)= MIN($ A $ 1,$ C $ 3,$ B $ 4),转置({1,2,3}),0))
EDIT: Likely an easy question, basically I have three values, let's say 9, 4 and 7 in different cells (not in a table), I want to find the minimum in an order then return its relative position, for example: 9,4,7 would return 2 as 4 is the minimum and is positioned second.
What is the correct excel formula to do so? Thanks .
Solution: Thanks all for your help, I didn't think excel could do if it wasn't continuous. I've ended up using a series of nested IF statements, an AND statement and < signs, to get the job done :)
Here's an array formula that should work. It assumes the values are in A1, C3, and B4.
=MAX(IF(CHOOSE(TRANSPOSE({1,2,3}),$A$1,$C$3,$B$4)=MIN($A$1,$C$3,$B$4),TRANSPOSE({1,2,3}),0))
这篇关于Excel公式位置的最小值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!