How do I input numbers used to select cells in several columns
You are welcome.
--
Kevin Vaughn
"BC2233" wrote:
Thanks Kevin works great!
"Kevin Vaughn" wrote:
AVERAGE(INDIRECT("k" & A22 & ":k" & A23))
MAX(INDIRECT("l" & A22 & ":l" & A23))
With start row in a22 and ending row in a23. Note: I used columns k and l
for my test (as I already suitable data in those columns.) Substitute AB for
k and Z for l.
--
Kevin Vaughn
"BC2233" wrote:
I am working with a customer supplied Excel worksheet where a range of cells
is selected for each use of the worksheet. For example the range may be row
52350 thru 53750 (note: this range varies with each file analyzed) There are
equations that would then use this range with data from various columns, such
as =average(AB52350:AB53750) and =max(Z52350:Z53750), etc. What I would like
to do is input the row numbers in a cell and have them automatically inserted
into the formulas.
|