Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i find the lowest number in a column in Excel?
I need to identify and mark the lowest number in a column in Excel.
|
#2
|
|||
|
|||
=MIN(Range)
to tag it, select the range and do formatconditional formatting formula is and =MIN(Range)=A1 where A1 is the first cell of the range Range needs to be a defined name or absolute reference -- Regards, Peo Sjoblom (No private emails please) "MKA808" wrote in message ... I need to identify and mark the lowest number in a column in Excel. |
#3
|
|||
|
|||
MKA808 Wrote: I need to identify and mark the lowest number in a column in Excel. Hi MKA808 Try =MIN(A2:A50), change the range to suit, or Data Filter Autofilter and filter the column containing the data, the lowest number will be top of the drop down list -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=398022 |
#4
|
|||
|
|||
Select the range of cells where you want to format the minimum number cell Select Format - Conditional Formating In input box choose equal to in the next box type =Min(range of cells) (make sure there are no inverted commas in equation) Click format and select the format way you want Click OK and the minimum value cell be formated the way you want :) -- instruite I am B.E. Instrumentation and Control and write now working as Hardware design engineer in automotive electrconics industry ------------------------------------------------------------------------ instruite's Profile: http://www.excelforum.com/member.php...o&userid=26539 View this thread: http://www.excelforum.com/showthread...hreadid=398022 |
#5
|
|||
|
|||
I tried what you suggested but and it did insert the formula into the range but the format marked all cells in that column. "Peo Sjoblom" wrote: =MIN(Range) to tag it, select the range and do formatconditional formatting formula is and =MIN(Range)=A1 where A1 is the first cell of the range Range needs to be a defined name or absolute reference -- Regards, Peo Sjoblom (No private emails please) "MKA808" wrote in message ... I need to identify and mark the lowest number in a column in Excel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
look up number in column | Excel Worksheet Functions | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
How do I find a column entry closest to a particular value | Excel Worksheet Functions | |||
How do I find a column entry closest to a particular value | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |