| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I return the highest value in a range of cells
How do I return the highest value in a range of cells
|
|
#2
|
|||
|
|||
|
=max(a1:a3)
-- HTH Bob Phillips "pjs83" wrote in message ... How do I return the highest value in a range of cells |
|
#3
|
|||
|
|||
|
try:
=MAX(A1:A100) Regards, KL "pjs83" wrote in message ... How do I return the highest value in a range of cells |
|
#4
|
|||
|
|||
|
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! |
|
#5
|
|||
|
|||
|
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! |
|
#6
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
| Can I use formulas that return cell range ref. in charts X series | Charts and Charting in Excel | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
| Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions | |||
| Excel: How to return count for each cell within date range criter. | Excel Worksheet Functions | |||
Linear Mode
