Quick help requested!! "Grouping" Formula or VBA fix

[mocp2008]

Hi Everyone, haven't been here in a while!

I'm desperately (and quickly!) needing a way to do the following. A formula is preferred, but a VBA method might work ok, too.

(Simplifying a bit here)..

In a column, let's say colC, I might have several "start" and "stop" points - these are placed to correspond with certain data in colD.

I'm looking for something that can identify all sets data BETWEEN this "Start" and "Stop" points in colC. So, looking for something which labels all that data as a particular word; "true", "data", "information" or something like that.

This formula will be in colB. Needs to begin identifying "grouping" when it catches a "Start" point in colC, and end grouping when it hits a "Stop" point in colC. It then leaves cells blank until it hits the NEXT "Start" point, then groups until the next "Stop" point, etc.

I've attached a bit of an example spreadsheet. Hopefully this makes sense! Thanks everyone!!