ExcelBanter - compare a list of numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - compare a list of numbers (https://www.excelbanter.com/excel-worksheet-functions/150896-compare-list-numbers.html)

Lucio

compare a list of numbers

Formula to compare a list of numbers in a row/column and obtain the highest

Toppers

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

Max

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

All times are GMT +1. The time now is 04:23 PM.