View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers
 
Posts: n/a
Default 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!