View Single Post
  #3   Report Post  
Paul Sheppard
 
Posts: n/a
Default


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