writing an formulae with variable parameters

I want to find the maximum (in each week) but along the years the first and
last position changes.

For that i use

"=MAX(D1241345)"

Now imagine that I want to use
"=MAX(D1251346)" and that i have that numbers in some colums

Can i change the formulae going to the numbers (it self)?

You could do it this way...

=MAX(INDIRECT("D125"&A1))

where I assumed the row number was in cell A1.

--
Rick (MVP - Excel)


"Formulas with variable parameters" Formulas with variable
wrote in message
news
I want to find the maximum (in each week) but along the years the first and
last position changes.

For that i use

"=MAX(D1241345)"

Now imagine that I want to use
"=MAX(D1251346)" and that i have that numbers in some colums

Can i change the formulae going to the numbers (it self)?

If you just use

=MAX(D)

then it doesn't matter where the rows with values are within the column.

HTH,
Bernie
MS Excel MVP


"Formulas with variable parameters" Formulas with variable
wrote in message news
I want to find the maximum (in each week) but along the years the first and
last position changes.

For that i use

"=MAX(D1241345)"

Now imagine that I want to use
"=MAX(D1251346)" and that i have that numbers in some colums

Can i change the formulae going to the numbers (it self)?