On Mon, 3 Mar 2008 11:51:01 -0800, billinr
wrote:

Thanks, Ron
That will give me the result I want, but I would have to run the copy/ paste
each time I use the sheet.
Can you suggest a macro or formula to make that happen automatically?

You can try recording your copy/paste keystrokes to start off developing a
macro.

Or you can post more detail about your data setup, how it changes, and what
sort of results you require, and we can probably come up with something here.
--ron