How to organize the excel file

Hewlett-packard / Dx2700
September 13, 2009 at 23:23:54
Specs: Windows Xp, Intel Core 2 Duo
I am using Microsoft Excel 2007. I want to make
exam time table in such a way that the invigilator
name is not conflicted with other department at
the same time. How can I track that one- how
can eliminate duplicate invigilator name at the
same time?


See More: How to organize the excel file

Report •

September 14, 2009 at 05:36:06
I think we need more details on this question:

"how can eliminate duplicate invigilator name at the same time? "

Report •

September 14, 2009 at 05:39:45

I think you can try the data validation in Excel 2007, first you need to prepare the list of all allowed invigilator names

select the name field to check
Click the
Data -> (In Data Tools) Data Validation -> Settings ->
Set Allow: to List
Set the Source to be the list you created.
Click OK
if you type something not from the list into the name field, you will get an error message.
Hope this helps.

Productivity Improvement in Computing

Report •

September 14, 2009 at 06:05:23

A bit more information is needed.

Presumably there could be several exams going on at the same time, hence a risk that one person is accidentally scheduled to invigilate in two places at once.

Will you have a timetable for each exam room?

If so, use a separate sheet for each exam room,
Each sheet should be identical in layout, with time periods throughout the working day and rows for name of exam taking place in each time period and the name of the invigilator for each time period.

You then add one more sheet with the same format of time periods, and which has a formula in each time period which tests that time slot (cell) in each room(sheet), for duplicate names.

As suggested by kakarukeys use data validation for entering invigilator names to ensure that you don't miss double booking, because of a typo in the name.

If there are a lot of exam rooms, a formula to test for no duplicates may become too complex and a macro to undertake the test may be appropriate, so please provide more details.


Report •

Related Solutions

Ask Question