ExcelBanter - How do I return the highest value in a range of cells

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

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

- - How do I return the highest value in a range of cells (https://www.excelbanter.com/excel-worksheet-functions/34143-how-do-i-return-highest-value-range-cells.html)

pjs83

How do I return the highest value in a range of cells

How do I return the highest value in a range of cells

Bob Phillips

=max(a1:a3)

--
HTH

Bob Phillips

"pjs83" wrote in message
...
How do I return the highest value in a range of cells

try:

=MAX(A1:A100)

Regards,
KL

"pjs83" wrote in message
...
How do I return the highest value in a range of cells

Domenic

In article ,
"pjs83" wrote:

How do I return the highest value in a range of cells

Try...

=INDEX(A1:A100,MATCH(MAX(A1:A100),A1:A100,0))

or

=INDEX(A:A,MATCH(MAX(A:A),A:A,0))

Hope this helps!

Domenic

Please ignore...

In article ,
Domenic wrote:

In article ,
"pjs83" wrote:

How do I return the highest value in a range of cells

Try...

=INDEX(A1:A100,MATCH(MAX(A1:A100),A1:A100,0))

or

=INDEX(A:A,MATCH(MAX(A:A),A:A,0))

Hope this helps!

Ron Rosenfeld

On Wed, 6 Jul 2005 13:04:02 -0700, "pjs83"
wrote:

How do I return the highest value in a range of cells

Look at HELP for the MAX worksheet function.

--ron

All times are GMT +1. The time now is 11:08 AM.