davestephsamem
New Member
- Joined
- Mar 3, 2012
- Messages
- 34
Hi,
I have a sheet that contains a timetable for a school - 16 class columns and 33 lesson rows. This "master" timetable is then sent to individual tabs for each teacher's individual timetable.
This results in a timetable that has one cell in each of the 16 rows with text that corresponds to their lesson title: they can't be in two places at once.
On occasions when there is no text within a row the teachers are "free" - I would like to have a mechanism where these "frees" are indicated. I was thinking of a formula in column 17 that does the job of "if there is any text in (e.g.) A1:P1 return nothing, otherwise return "free"". I sort of managed it - but it spills...
Thanks
Dave
I have a sheet that contains a timetable for a school - 16 class columns and 33 lesson rows. This "master" timetable is then sent to individual tabs for each teacher's individual timetable.
This results in a timetable that has one cell in each of the 16 rows with text that corresponds to their lesson title: they can't be in two places at once.
On occasions when there is no text within a row the teachers are "free" - I would like to have a mechanism where these "frees" are indicated. I was thinking of a formula in column 17 that does the job of "if there is any text in (e.g.) A1:P1 return nothing, otherwise return "free"". I sort of managed it - but it spills...
Thanks
Dave