find the largest number in column

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

How do get Excel (Ofc 2000) to check all the numbers in column B to find the
largest number and copy it into cell C3?

Jack
 
Jack said:
How do get Excel (Ofc 2000) to check all the numbers in column B to find the
largest number and copy it into cell C3?

Jack
Click to expand...

In C3, enter =MAX(B:B)

/Fredrik
 
Jack,

Use the MAX function. In cell C3, use the following formula:

=MAX(B:B)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
To check Column A, enter this in cell C3:

=MAX(A:A)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



How do get Excel (Ofc 2000) to check all the numbers in column B to find the
largest number and copy it into cell C3?

Jack
 
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

Find values across a row and return a text value from the same column 2
adding largest numbers 2
Finding a folder with the largest number. 1
Determine average of largest 5 numbers in a column. 6
Cannot sort data 6
Find 3 numbers +/- 26 rows from each other 2
Formula help 1
condionally formatting based on another cells formatting? 2

Back
Top