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?

"Trevor Shuttleworth" wrote:

I guess you could either name it or use absolute reference to it, for
example $D$3

Regards

Trevor


"ridemore" wrote in message
...
how can i designate one cell as a variable to be used in moving average or
max/min formulas?