writing an formulae with variable parameters

  • Thread starter Formulas with variable parameters
  • Start date
F

Formulas 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)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I reference the cell which returned a lookup value? 1
Drop down list control value in vba 2
Using MAX with a LOOKUP 3
Finding the weighted average of text that have been given values 1
Formula for calculating target hours against actual hours 12
Max/Min per item from a changing list 0
Making MAX and MIN range variable 1
Find Max from Variable Range 6

Top