| 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 | |||
Hybrid Mode
