Find secound value in column

I have this code that selects from "CO OW Market" to "GRP Total" in a column

Please Login or Register  to view this content.

Perfect, but in need to do the same thing, but this time select from "CO OW Market" to "GRP Total" in the same column after the first. meaning "CO OW Market" and "GRP Total" come up twice in the same columun.

example:

D6 = CO OW Market

D8 = GRP Total

D26 = CO OW Market

D45 = GRP Total


I need to select from D26 to D45. They will not always be in the same rows is why I need to find it. They will be in that order though

Maybe:

Please Login or Register  to view this content.

Thanks , it had a pop up that notified me of the range that it was in. I need it to select from "CO OW Market" to "GRP Total" the secound time they both apear just like

Please Login or Register  to view this content.

did for the first time they appeared.

Try:

Please Login or Register  to view this content.

Will there always only be 2 occurances?