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!
|