View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Formulas with variable parameters Formulas with variable parameters is offline
external usenet poster
 
Posts: 1
Default 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(D124:D1345)"

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

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