delete the formula in the cells with the error message.

Let's say you have the numbers 1-75 in random order in cells A1:A100
with the remaining cells in this range blank. In column B you only
need to copy the formula down the range of B1:B75 (as you are only
going to return 75 numbers).

However, if you don't know exactly how many numbers are in the range,
you simply copy the formula down the entire range in B and then delete
those that return the error message.

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=467250