"Shay" <nomail@nomail> wrote:
> I've got a spreadsheet here of employee schedules. Each column represents an
> employee, and each row a date. A typical column would look like:
>
> Name
> off
> off
> off
> ---start
> work
> work
> work
> work
> work
> ---end
> off
> off
> off
>
> Looking for a tip for the best way to change the start and end rows and have the
> rest update. I know there's a scripting language, but I'm looking for a solution
> that won't scare others away. The current copy-paste method being used is
> producing a lot of errors.

You can do something like that:

=If(OR(C4="";C4="end");"off";IF(OR(C4="start";C4="work");"work";"off"))
Put that in cell C5 (that's where I started) and copy it wherever you need it

It will fill out all cells with "off" if the cell above is anything but "start"
or "work", and anything after "end" is "off" again.

Regards
Aydan

Post a reply to this message