How select every 4th week

[Tony Ramsden]

I'm currently devising a sheet to work out company oncall. We have 3
people on call at one time ( from a group of10 ), 2 do a 1 in 2,
I am using the ISEVEN function on the week number to do this one. (
Easy )
Others do a 1 in 4 rotation -- How do I manage to get this in the
sheet..

Any help gratefully received.



Tony

 

[Tony Ramsden]

Maybe I should expand

I have 1 workbook with 2 sheets, Sheet one contains the Week
number,the Monday to Sunday r and the guys on call.

Sheet 2 contains the workers

I want to be able to put the week number in manually and hey presto
the sheet tells me which 3 guys are on call..

Thanks

Tony

 

[Bernard Liengme]

I think we need the layout of the first sheet given to us more clearly. What
is in column A, what in B....
Bernard

 

[Tony Ramsden]

OK
Sheet 1
Column A=Monday, Column B=Tuesday etc
Row 6,7,8 to contain workers name as they are oncall

Row 1 to 5 contains Headers, with the manual input of week number
being B3

Sheet 2 contains the workers names
Column B is the Names
Column D are the commitments ( 2,3 or 4 dependon wether they are
oncall 1 in 2weeks , 1 in 3 weeks or 1 in 4 Week ) I've done it this
way so commitments can be changed regularly.

Hope this helps..

Thanks

Tony

 

[Gerrit]

use MOD divided 4
when jou can A1 divide by 4 and the mod = 0 the anser is true 0, 4,8,12,16
etc etc

=MOD(A1,4)=0 '0,4,8,12 etc.....
=MOD(A1,4)=1 '15,9,13 etc.....
etc..