On Thu, 28 Jul 2011 10:48:29 -0400, lehigh46 wrote:

I apologize. You're formulas worked perfectly.
I was so excited to see a response that I inadvertently used the same
cell location as was in my example. (I used A1 for simplicity)
When I typed your formula in my sheet I used A1. In reality it should
have been C10.
Again, I apologize.

A thousand thanks!

Thank you for clarifying. Be sure to mark joeu's response as an Answer.