find the largest number in column

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
 
F

Fredrik Wahlgren

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
 
C

Chip Pearson

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
 
R

RagDyeR

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
 
Top