if i have a row or column of numbers, what formula do i use to pick out the
largest numer... i.e. 10, 14, 6, 28, 59, 37... i need to pull out 59

dnmusic wrote:
if i have a row or column of numbers, what formula do i use to pick out the
largest numer... i.e. 10, 14, 6, 28, 59, 37... i need to pull out 59


Look at MAX and LARGE in the help file.

use =MAX()

=MAX(A:A) if down a column or =MAX(1:1) if in a row.

"dnmusic" wrote:

if i have a row or column of numbers, what formula do i use to pick out the
largest numer... i.e. 10, 14, 6, 28, 59, 37... i need to pull out 59

If data is real numbers, then just normal Enter, eg in B1: =MAX(A1:A10)
If data is text numbers or a mix of text/real numbers,
then array Enter* in B1: =MAX(A1:A10+0)
*press CTRL+SHIFT+ENTER to confirm the formula
Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"dnmusic" wrote:
if i have a row or column of numbers, what formula do i use to pick out the
largest numer... i.e. 10, 14, 6, 28, 59, 37... i need to pull out 59

You can use,
=Large(your range of number here, 1)
replace your range of number here with your actual range (row and/or column)
You can check the large function under help



"dnmusic" wrote:

if i have a row or column of numbers, what formula do i use to pick out the
largest numer... i.e. 10, 14, 6, 28, 59, 37... i need to pull out 59