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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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).
 

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

HOW TO TOTAL THE THREE HIGHEST AMOUNTS IN A ROW 2
How can I sort data and have the highest value red, 2nd blue, ect 3
display order of values without sorting 2
highest second highest and third highest 6
How do I find the second highest value. 3
A Sorting Dilemna 1
Possible to "understand and pull" highest value from column B..... 3
Sorting a List and determining value 1

Back
Top