| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare a list of numbers
Formula to compare a list of numbers in a row/column and obtain the highest
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
compare a list of numbers
=MAX(A:A)
will give largest in column A "Lucio" wrote: Formula to compare a list of numbers in a row/column and obtain the highest |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I compare tow columns of numbers? | Excel Discussion (Misc queries) | |||
| VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
| How to compare two cells for the same numbers | Excel Worksheet Functions | |||
| How to compare 3 numbers and return value | Excel Worksheet Functions | |||
| How can I compare a number against a list of numbers | Excel Worksheet Functions | |||
Linear Mode
