Ever-changing ranges - define based on repeated cell contents

[troyaaron]

Hi,

This is what I need to happen, imagine these values in column B:

Mon 1
Mon 1
Mon 1
Mon 2
Mon 2
Mon 2
Mon 2
Mon 2
Mon 3
Mon 4
Mon 4
Tue 1

I want to be able to identify when the value changes from Mon to Tue and create range definitions I can then use later on...so the resulting range variables from this example would be:
B1:B3
B4:B8
B9
B10:B11

Is this possible?

 

[troyaaron]

Help, please?