View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default compare a list of numbers

In say, B1: =MAX(A:A)
returns the max in col A

In say, A2: =MAX(1:1)
returns the max in row 1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lucio" wrote:
Formula to compare a list of numbers in a row/column and obtain the highest