R
ridemore
how can i designate one cell as a variable to be used in moving average or
max/min formulas?
max/min formulas?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Trevor Shuttleworth
I guess you could either name it or use absolute reference to it, for
example $D$3
Regards
Trevor
example $D$3
Regards
Trevor
R
ridemore
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?
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?
J
JulieD
Hi
=MAX(INDIRECT("A1:A" & C1 & ""))
where C1 contains the value of "N"
Cheers
JulieD
=MAX(INDIRECT("A1:A" & C1 & ""))
where C1 contains the value of "N"
Cheers
JulieD
R
ridemore
excellent - thank you!
JulieD said:Hi
=MAX(INDIRECT("A1:A" & C1 & ""))
where C1 contains the value of "N"
Cheers
JulieD
J
JulieD
R
Rookie 1st class
Wanted to treat Mistress Julie to dinner for this solution...wifey said NO!
<No one looking> sends big wet kiss. Seriously; THANKS
<No one looking> sends big wet kiss. Seriously; THANKS