How do i calculate a difference formula in a column of numbers in.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to figure a formula that would find the difference between the
highest and lowest number in a column in Excel 2000. Each week another
number is added. Any help would be greatly appreciated.
 
If column A has your numbers:

=MAX(A:A)-MIN(A:A)

You can still add rows to the end of the list because you are referencing
the entire column.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding most recently entered number within a column 3
Trying to find additional ranges outside of min, max, and average 2
Excel What Function shows value between highest and lowest number 2
Copying formulas across columns 2
Formula to add 4 lowest numbers from a column of 6 4
returning a text value using a formula 1
Calculate total by row number 4
How do you do an IF statement in Excel comparing three columns 1

Back
Top