[SOLVED] Dividing the last in a series

Is the data always in ascending sequence so you divide the maximum by the
minimum?

=max(A1:A10)/min(A1:A10)

HTH

"jezzica85" wrote:

> Hi all, I have a spreadsheet like this:
> 3000
> 4000
> 5000
> 6000
>
> I want to divide the last number by 3000, and only the last number. If I
> add another number on after the last one, say 7000, I want to divide that
> one, and only that one. Is there a way to do that?
> Thanks!

No, the data isn't always in ascending sequence.

"Toppers" wrote:

> Is the data always in ascending sequence so you divide the maximum by the
> minimum?
>
> =max(A1:A10)/min(A1:A10)
>
> HTH
>
> "jezzica85" wrote:
>
> > Hi all, I have a spreadsheet like this:
> > 3000
> > 4000
> > 5000
> > 6000
> >
> > I want to divide the last number by 3000, and only the last number. If I
> > add another number on after the last one, say 7000, I want to divide that
> > one, and only that one. Is there a way to do that?
> > Thanks!

For some reason my earlier post didn't show up, no, the data isn't always in
ascending order.

"Toppers" wrote:

> Is the data always in ascending sequence so you divide the maximum by the
> minimum?
>
> =max(A1:A10)/min(A1:A10)
>
> HTH
>
> "jezzica85" wrote:
>
> > Hi all, I have a spreadsheet like this:
> > 3000
> > 4000
> > 5000
> > 6000
> >
> > I want to divide the last number by 3000, and only the last number. If I
> > add another number on after the last one, say 7000, I want to divide that
> > one, and only that one. Is there a way to do that?
> > Thanks!