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
|