Reply

1. I'd like to clear the contents of just duplicates in columns a and
b, unless the word equals = subtotal. Then, I want it to stay the same
(forgot to mention that).

2. The subtotal row is already there.

3. And, Yes.

4. The data isn't sorted it is already just grouped together when I open
up the raw data.

Any ideas James?

Thanks,

Kelly

*** Sent via Developersdex http://www.developersdex.com ***