How do I input numbers used to select cells in several columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Thanks Kevin works great!

Kevin Vaughn said:
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.
Click to expand...
 
Back
Top