I want to use the =MAX() function but get the start and stop cell from cell values:
我想使用= MAX()函数,但从单元格值获取启动和停止单元格:
Given cell-values like this:
给定像这样的单元格值:
A1 = 110 (the row start)
A1 = 110(行开始)
A2 = 130 (the row end)
A2 = 130(行结束)
A3 = 4 (the column-id ie "D")
A3 = 4(列-id即“D”)
Using this the max function should become
使用此功能应该成为最大功能
MAX(D110:D130)
When I change the cell values the range MAX uses should change. Any way to do this? INDIRECT seems useful but i cannot make it work. Im using the same worksheet for everything.
当我更改单元格值时,MAX使用的范围应该更改。有什么办法吗? INDIRECT似乎很有用,但我无法使其发挥作用。我使用相同的工作表。
Thanks!
1 个解决方案
#1
2
Try this:
= MAX(INDEX($A:$XFD,A1,A3):INDEX($A:$XFD,A2,A3))
Quick note: INDIRECT should be avoided because it is volatile. INDEX is preferred.
快速注意:应该避免间接因为它是易变的。 INDEX是首选。
#1
2
Try this:
= MAX(INDEX($A:$XFD,A1,A3):INDEX($A:$XFD,A2,A3))
Quick note: INDIRECT should be avoided because it is volatile. INDEX is preferred.
快速注意:应该避免间接因为它是易变的。 INDEX是首选。