| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference the 2nd and 3rd highest in range.
I have a spreadsheet of tables each references the MAX in each totals column
using the MAX function (e.g. =MAX(J8:J92)). Using this I can conditionally format a column to highlight the highest just by referencing the MAX cell.(=IF(J$7=0,"",(J32=J$7)) How would I add a conditional format for the second and third highest numbers in a range? I'd appreciate any feedback. Thanks in advance for any help. Rory |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Reference the 2nd and 3rd highest in range.
Have a look at LARGE in help
=LARGE(A1:A15,1) =LARGE(A1:A15,2) etc Mike "rory_r" wrote: I have a spreadsheet of tables each references the MAX in each totals column using the MAX function (e.g. =MAX(J8:J92)). Using this I can conditionally format a column to highlight the highest just by referencing the MAX cell.(=IF(J$7=0,"",(J32=J$7)) How would I add a conditional format for the second and third highest numbers in a range? I'd appreciate any feedback. Thanks in advance for any help. Rory |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Reference the 2nd and 3rd highest in range.
Thanks Mike, thatll' help a lot.
Rory "Mike H" wrote: Have a look at LARGE in help =LARGE(A1:A15,1) =LARGE(A1:A15,2) etc Mike "rory_r" wrote: I have a spreadsheet of tables each references the MAX in each totals column using the MAX function (e.g. =MAX(J8:J92)). Using this I can conditionally format a column to highlight the highest just by referencing the MAX cell.(=IF(J$7=0,"",(J32=J$7)) How would I add a conditional format for the second and third highest numbers in a range? I'd appreciate any feedback. Thanks in advance for any help. Rory |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to find highest value of a vlookup reference | Excel Discussion (Misc queries) | |||
| How can i get the 3 highest in a range | Excel Discussion (Misc queries) | |||
| Highest Value / Circular Reference Help | Excel Discussion (Misc queries) | |||
| Highest Value / Circular Reference Help | Excel Worksheet Functions | |||
| Highest Value from Unique range | Excel Worksheet Functions | |||
![rory_r[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
