John

If I was rating your answer I would give it a low rating.

There are several ways to do this using a formula.


Gord Dibben MS Excel MVP


On Thu, 18 Jun 2009 09:13:09 -0700, John Bundy (remove)
wrote:

You won't accomplish that with just a formula. You can do it easily with a
number of different macros, but they all involve a method you didn't want to
do.