Ken, your second solution works!

Unbelievable. I still only understand about half of what you're doing, but I tested it on some more test data and it works.

Thank you very much.

Ken and Phil,

Thank you very much for looking at this. I really appreciate it. I've been in meetings all day and just started looking at your responses. I wanted to...

Thanks for the response ktflash. I agree, code will make it easier. The details are below.

triplAxe, thanks for the response. I tried a running total, but that didn't work. Hopefully...

• This reply was modified 3 years, 3 months ago by  John O'Connor.