how can i identify three highest values in a column (not sort)
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).
Mistysweep wrote:
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.
--
Many thanks
Mistysweep
--
Dave Peterson
|