View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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