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
<tbody>
</tbody>
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
2002 | 2003 | ART 101 | ART | 101 | INTRODUCTION TO ART | 3 |
2003 | 2004 | ART 101 | ART | 101 | INTRODUCTION TO ART | 3 |
2004 | 2005 | ART 101 | ART | 101 | INTRODUCTION TO ART | 3 |
2005 | 2006 | ART 101 | ART | 101 | INTRODUCTION TO ART HISTORY | 3 |
2006 | 2007 | ART 101 | ART | 101 | INTRODUCTION TO ART | 4 |
2007 | 2008 | ART 101 | ART | 101 | INTRODUCTION TO ART | 4 |
<tbody>
</tbody>