Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort column with multiple values | New Users to Excel | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
linking values of column A to values of column B | Excel Discussion (Misc queries) | |||
Finding (Multiple) Highest Values in Column | Excel Worksheet Functions | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions |