如何水平拖动一个固定的字符串的公式 [英] how to drag horizontally a formula which is a string fixed
问题描述
我在excel中有以下公式
I have the following formula in excel
= MAX(INDIRECT($ A2&!&B2:B5 ))
A2是当前工作表中的一个单元格,它是工作表选项卡的名称。但是我想做的就是将公式拖放到标准excel公式中,以引用其他工作表选项卡的单元格
A2 is a cell in the current worksheet, which is the name of a worksheet tab. However what i wish to do is drag the formula horizontally like that of standard excel formulas to reference the cells of the "other" worksheet tab
所以如果我水平拖动,我会得到:
So if i dragged horizontally i would get:
= MAX(INDIRECT($ A2&!&C2:C5))
= MAX(INDIRECT($ A2&!&D2:D5))
等
这不会使用公式作为固定的文本...我该怎么办?
This wont work with the formulas as a fixed text..so how would i do this?
推荐答案
这将解决您的问题。虽然不知道这是否是最佳解决方案。
This will solve your problem. Though not sure whether this is the best solution.
=MAX(INDIRECT($A2 & "!" & CHAR(COLUMN()+64) & "2:" & CHAR(COLUMN()+64) & "5"))
这篇关于如何水平拖动一个固定的字符串的公式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!