Noted.

-miniman

On Thu, 18 Sep 2008 20:55:35 -0400, "Rick Rothstein"
wrote:

My mistake, I forgot to mention that I need a cell formula,
not a vba solution.

Since this is a programming newsgroup, it will normally provide VBA
solutions. If you are seeking formula solutions in the future, the
microsoft.public.excel.worksheet.functions would be a better newsgroup to
post to for them.