Excel invigilator arrangement table, densely packed with invigilators' names. How can I know all the invigilation arrangements of a teacher quickly and accurately?
Find an empty cell (such as K 1) outside the invigilation schedule and fill in the name of the teacher to be inquired.
Suppose the teacher's name area in your invigilation arrangement is A2:H40.