Just to clear up some uncertainty - below is an abbreviated range of the
actual worksheet (Sheet 1). On a seperate worksheet (Sheet 2) with all
subjects and groups for cross reference, I tried formulas
(IF,AND,SUMIF,AND,OR, etc.) to mark with an "x" which subjects had been
assigned to which group. For example:

=IF(AND(B20:E24="L2DM",B20:E24="Eng. Drawing"),"x",""))

This is a HUGE worksheet (1000+ students) and drawing up this time-table to
mark on a seperate worksheet (Sheet 2) if Mathematics has been assigned to
group L2DM, got me completely baffled. Some cells are merged as well (in
case where one subject has to be assigned to two groups).

A B C D
E
19 Time Group Subject Group Subject
20 07:45 L2BM Eng. Science L2FT Mathematics
21 L2DM Motor Theory L2EL Ind. Electronics
22
23 08:45 L2BM Platers' Theory L2FT F & M Theory
24 L2DM Eng. Drawing L1EL Mathematics

Somehow I don't see the light at the end of the curved tunnel!

Thanx