Reference the 2nd and 3rd highest in range.

R

rory_r

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function for 2nd and third low or Max 2
select max value from row of data and column containing max value 1
Conditional formatting based on max in range of other columns 2
Finding (Multiple) Highest Values in Column 1
Indicating the first occurance of the max value in a range 1
Average of values in row excluding the highest and lowest value? 18
Selecting the 2nd highest value in a row. 2
How do i get the top 5 numbers in a range of cells? 1

Top