to add

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

an array formula

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

increment the "2" in the small function as required to get the 4th
lowest, 5th lowest, etc
__________________


--
duane


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