View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JH JH is offline
external usenet poster
 
Posts: 64
Default picking largest number

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