Thanks

But it did not work because the problem is that the other two cells
have errors in them so functions like max and large need to have whole
numbers, i need a formula that would be able to read errors and then
display to only cell without an error

Andrew


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=501901