Hi,
I have data in the range A1:E1000, with the following fields:
A2:E2 - Headings for columns, respectively Product, Date, Colour, Sales and Sales
The Sales columns above can be distinguished from one another by the text "Country1" in cell D1 and "Country2" in cell E1.
From the above...