how can i identify three highest values in a column (not sort)

M

Mistysweep

Hi,

I have a colum of data aist and would like to be able to highlight the three
highest values in the column, but don't want to sort the data.
 
D

Dave Peterson

Maybe you could use format|conditional formatting to highlight those cells?

Select your range
(I used A1:A20)
and with A1 the activecell
format|conditional formatting
formula is
=A1>=LARGE(A:A,3)

This will highlight all the values that are greater than the 3rd highest value
(watch what happens with ties).
 
Top