Thread: Maximum & Minimum values in a coulmn
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
duane duane is offline
external usenet poster
  
Posts: 1
Default Maximum & Minimum values in a coulmn

="C"&MATCH(MIN($C:$C),$C:$C,0)

will result in the cell in column c with the minimum (non blank) value

="C"&MATCH(MIN(IF(NOT(ISBLANK(C1:C1000)),IF(C1:C10 00<MIN(C1:C1000),C1:C1000))),C:C,0)

an array formula

will result in the cell in column c with the 2nd lowest (non blank)
value - note this requires a specific range


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=562726

Reply With QuoteReply With Quote