"Automatically" by "trial and error"? Unless I'm misunderstanding your
question trial and error would imply that you try it and keep trying it
until you get the right answer.

Signature
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com/excel.htm
> How do I calculate the z factor automatically by trial & error
>
> EggHeadCafe - .NET Developer Portal of Choice
> http://www.eggheadcafe.com