Okay so i found that hte problem has to do with if the cell has #NUM! i
it.

How can I change hte formula
=SMALL($I$83:$I$102,1)

to be blank and not #NUM! if there are no valued in the range?

Thanks

--
Message posted from http://www.ExcelForum.com