Hi Jon

Some ways...for this(using formula--Not VBA), you'll find here.

http://www.excelforum.com/excel-gene...s-formula.html