Conditional counting of a string in 2 columns

Why is your data as it is?
This is nigh impossible to process as you want, and even if it can be solved, why make life hard?

It makes much more sense to have each "order" in a seperate line. not concatenated in individual cells.

What does your real data look like?

Originally Posted by Marcol

Why is your data as it is?

It makes much more sense to have each "order" in a seperate line. not concatenated in individual cells.

The problem is, it's the way our .xls file is organized at work and I have no authority to change it.

P.S. Thanks, your script works!