| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Needed for lowest three values in a Column
Use conditional formatting, and a formula like:
=a1=small(a:a,1) Regards, Fred "frankjh19701" wrote in message ... I need a formula that will find the lowest three values in a given row or column. I would like to be able to highlight them in different colors. Any/all assistance is greatly appreciated. Thank you -- frankjh19701 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create formula to; sum the lowest 10 cells in a column | Excel Worksheet Functions | |||
| Formula to add 4 lowest numbers from a column of 6 | Excel Worksheet Functions | |||
| formula help needed (if values) | Excel Discussion (Misc queries) | |||
| Formula to higlight highest and lowest values in row | Excel Worksheet Functions | |||
| How can I average certain number of lowest values in a column? | New Users to Excel | |||
![Fred Smith[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
