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

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


"ridemore" <[email protected]> wrote in message
news:[email protected]...
> how can i designate one cell as a variable to be used in moving average or
> max/min formulas?

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" <[email protected]> wrote in message
> news:[email protected]...
> > how can i designate one cell as a variable to be used in moving average or
> > max/min formulas?
>
>
>

Hi

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

where C1 contains the value of "N"

Cheers
JulieD


"ridemore" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > how can i designate one cell as a variable to be used in moving average
>> > or
>> > max/min formulas?
>>
>>
>>

excellent - thank you!

"JulieD" wrote:

> Hi
>
> =MAX(INDIRECT("A1:A" & C1 & ""))
>
> where C1 contains the value of "N"
>
> Cheers
> JulieD
>
>
> "ridemore" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > how can i designate one cell as a variable to be used in moving average
> >> > or
> >> > max/min formulas?
> >>
> >>
> >>
>
>
>

you're welcome and thanks for the feedback

"ridemore" <[email protected]> wrote in message
news:[email protected]...
> excellent - thank you!
>
> "JulieD" wrote:
>
>> Hi
>>
>> =MAX(INDIRECT("A1:A" & C1 & ""))
>>
>> where C1 contains the value of "N"
>>
>> Cheers
>> JulieD
>>
>>
>> "ridemore" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> > how can i designate one cell as a variable to be used in moving
>> >> > average
>> >> > or
>> >> > max/min formulas?
>> >>
>> >>
>> >>
>>
>>
>>

Wanted to treat Mistress Julie to dinner for this solution...wifey said NO!
<No one looking> sends big wet kiss. Seriously; THANKS

"JulieD" wrote:

> you're welcome and thanks for the feedback
>
> "ridemore" <[email protected]> wrote in message
> news:[email protected]...
> > excellent - thank you!
> >
> > "JulieD" wrote:
> >
> >> Hi
> >>
> >> =MAX(INDIRECT("A1:A" & C1 & ""))
> >>
> >> where C1 contains the value of "N"
> >>
> >> Cheers
> >> JulieD
> >>
> >>
> >> "ridemore" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > 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" <[email protected]> wrote in message
> >> >> news:[email protected]...
> >> >> > how can i designate one cell as a variable to be used in moving
> >> >> > average
> >> >> > or
> >> >> > max/min formulas?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>