catch and report overlap times

[modiria50989]

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

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

<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>

 

[modiria50989]

Update please:

How can I use excel formula functions to have another column/columns that puts corresponding "CRN" number/numbers if there is/are overlap/overlaps?