The probability of randomly meeting your criteria must be billions to
one though. If you wrote a macro to do what you want it would take ages
to meet the criteria.

Probability = (0.01^5) * 5 = 2,000,000,000:1 (2 billion to 1)


--
TheRobsterUK


------------------------------------------------------------------------
TheRobsterUK's Profile: http://www.excelforum.com/member.php...fo&userid=9924
View this thread: http://www.excelforum.com/showthread...hreadid=470037