designate one cell as the variable N to be used for calc...

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

Guest

how can i designate one cell as a variable to be used in moving average or
max/min formulas?
 
I guess you could either name it or use absolute reference to it, for
example $D$3

Regards

Trevor
 
thanks for responding - let me clarify - i want to be able to get a max for a
dataset but i want the max to reference a variable number of cells in the
data set that i can change on the fly in one cell - so if the column has 1000
rows and i want the max value from cells 1 thru 50 then i want the max from 1
thru 60 or 1 thru "N", can i have an absolute reference that gives the number
of the cells "N" i wish to include in the max data set?
 
Hi

=MAX(INDIRECT("A1:A" & C1 & ""))

where C1 contains the value of "N"

Cheers
JulieD
 
Wanted to treat Mistress Julie to dinner for this solution...wifey said NO!
<No one looking> sends big wet kiss. Seriously; THANKS
 
You must log in or register to reply here.

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

Trying to find additional ranges outside of min, max, and average 2
getting pivot to show finctions data calcs across columns, not down rows 3
#DIV error 2
Making MAX and MIN range variable 1
#N/A In Cells 7
Variable Cell Range Reference 3
calculating moving averages.. 4
XL how to change a cell reference in a formula to variable value? 6

Back
Top