Capturing Catalog Data

[jasbentle]

Hello all!
I am wanting to take information and put it in a separate worksheet if all the information is the same in column C, F, and G
If so, I would like to pull the Low Year (Column A) and High Year (Column B)

So basically want to say from 2002 - 2005/ ART 101/ INTRODUCTION TO ART/3 CREDITS was all the same
in year 2005 the class changed to ART 101/ INTRODUCTION TO ART HISTORY/3 CREDITS and will be that way for infinity (99999) or until a change happens to column(s) C, F, or G.

Thoughts?



A B C D E F G

[TABLE="width: 613"]
<tbody>[TR]
[TD]2002[/TD]
[TD]2003[/TD]
[TD]ART 101[/TD]
[TD]ART[/TD]
[TD]101[/TD]
[TD]INTRODUCTION TO ART[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]2003[/TD]
[TD]2004[/TD]
[TD]ART 101[/TD]
[TD]ART[/TD]
[TD]101[/TD]
[TD]INTRODUCTION TO ART[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]2004[/TD]
[TD]2005[/TD]
[TD]ART 101[/TD]
[TD]ART[/TD]
[TD]101[/TD]
[TD]INTRODUCTION TO ART[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]2005[/TD]
[TD]2006[/TD]
[TD]ART 101[/TD]
[TD]ART[/TD]
[TD]101[/TD]
[TD]INTRODUCTION TO ART HISTORY[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]2006[/TD]
[TD]2007[/TD]
[TD]ART 101[/TD]
[TD]ART[/TD]
[TD]101[/TD]
[TD]INTRODUCTION TO ART[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]2007[/TD]
[TD]2008[/TD]
[TD]ART 101[/TD]
[TD]ART[/TD]
[TD]101[/TD]
[TD]INTRODUCTION TO ART[/TD]
[TD="align: right"]4[/TD]
[/TR]
</tbody>[/TABLE]

 

[jasbentle]

bump. Can anyone help?