modiria50989
New Member
- Joined
- Aug 11, 2017
- Messages
- 32
Hello, I have a table like bellow. How can I use excel formula functions to have another column/columns that puts corresponding "Course" name/names if there is/are overlap/overlaps? Thank you
<colgroup><col width="64" style="width: 48pt;" span="5">
<col width="78" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2759;">
<col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2360;">
<tbody>
</tbody>
CRN | COURSE | SECTION | DAY1 | DAY2 | START TIME | END TIME |
13161 | ECE 361 | Lecture | TU | TH | 11:00 | 12:20 |
13177 | ECE 361 | Lab | M | 11:00 | 11:50 | |
13176 | ECE 361 | Lab | M | 10:00 | 10:50 | |
13175 | ECE 361 | Lab | M | 9:00 | 9:50 | |
10266 | ECE 491 | Lecture | W | 17:00 | 17:50 | |
10271 | ECEP 354 | Lecture | TU | TH | 9:00 | 10:20 |
11009 | ECEP 354 | Lab | TH | 14:00 | 15:50 | |
10187 | ECEP 354 | Lab | W | 11:00 | 12:50 | |
12165 | ECEP 371 | Lecture | M | 14:00 | 15:50 | |
10284 | ECEP 411 | Lecture | TU | TH | 12:30 | 13:50 |
15694 | ECEP 451 | Lecture | M | 18:00 | 20:50 | |
11166 | ECE 203 | Lecture | TH | 12:00 | 13:50 | |
15680 | ECE 203 | LAB | TH | 17:00 | 18:50 | |
15679 | ECE 203 | LAB | W | 15:00 | 16:50 | |
15678 | ECE 203 | LAB | W | 13:00 | 14:50 |