Excel公式查找其他单元格使用的参考 [英] Excel formula to find reference used by other cell
问题描述
有没有办法找出excel中另一个单元格中引用的单元格的地址?
Is there a way to find out the address of the cell being referenced in another cell in excel?
例如。单元格C1包含公式= max(A:A),并返回实际引用到单元格A10的值10。我可以在单元格B中使用一个返回'A10'的公式吗?
E.g. cell C1 contains formula =max(A:A) and returns a value of 10 which is actually referenced to cell A10. Can I use a formula in cell B that returns 'A10'?
不,我根本不想使用VBA。
And no, I don't want to use VBA at all.
推荐答案
假设您的条目位于单元格A1:A7中,您可以这样做...
Assuming that your entries are in Cells A1:A7, you can do it this way ...
在单元格 B1 中,单元格 = MAX(A1:A7)和
> B2 ,范围内最大数字(如B1所示)的单元格位置由公式
in Cell B2, the cell location of the maximum number in the range (shown in B1) is given by the formula
= CELL(address ,INDEX(A1:A7,MATCH(MAX(A1:A7),A1:A7,0)))
OR
= ADDRESS(MATCH(MAX(A1:A7),$ A $ 1:A7,0),1)
如果有帮助,将其标记为答案。
Mark as answer if it helps.
这篇关于Excel公式查找其他单元格使用的参考的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!