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

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

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