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

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

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

Look at LARGE function

=Large(A1:A1000,1) will largest

HTH

"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

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

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

"that are greater than" should have been "that are greater than or equal to"



Dave Peterson wrote:

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

--

Dave Peterson