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!