Dale Thompson
New Member
Hi Guys, I'm doing up a roster for a friend of mine and he basically wants the rosters rotation to always start from say employee 1(a1) and end in employee 15(a15) but he wants to be able to add and delete people from the roster without having the display sheet messing up.
So in Sheet 2 I have a list of people available to work , there is now 15 people but he has authority to add up to 15 more workers making the total 30. If you look in the first pic I uploaded you will see how I have set it out, so where placeholder appears he wants to be able to add an employee and have it automatically add to the roster.
So in the roster I have a1=worker1 and in a2 =if(a1=worker1,worker2
and then a continuing nested if statement all the way up to 30, so that regardless of which employee he starts the roster from the next in line will automatically be added in.
Now the problem I'm having is at the moment we only have 15 employees listed, so when we get to the 15th employee he wants the roster to start again at 1 and not display "Place Holder" or a blank cell.
so the formula I have so far is simply nested if statements
=IF(F33=worker1,worker2,IF(F33=worker2,worker3,IF(F33=worker3,worker4,IF(F33=worker4,worker5,IF(F33=worker5,worker6,IF(F33=worker6,worker7,IF(F33=worker7,worker8,IF(F33=worker8,worker9,IF(F33=worker9,worker10,IF(F33=worker10,worker11,IF(F33=worker11,worker12,IF(F33=worker12,worker13,IF(F33=worker13,worker14,IF(F33=worker14,worker15,IF(F33=worker15,worker16,IF(F33=worker16,worker17,IF(F33=worker17,worker18,IF(F33=worker18,worker19,IF(F33=worker19,worker20,IF(F33=worker20,worker21IF(F33=worker21,worker22,IF(F33=worker22,worker23,IF(F33=worker23,worker24,IF(F33=worker24,worker25,IF(F33=worker25,worker26,IF(F33=worker26,worker27,IF(F33=worker27,worker28,IF(F33=worker28,worker29,IF(F33=worker29,worker30)))))))))))))))))))))))))))))
now the way I have it set if he wants to start at worker15 the next one to show up is "Place Holder" what I want is for it to recognize that if place holder comes up revert to worker1
Ive tried and statements etc but I'm brick walling.
So in Sheet 2 I have a list of people available to work , there is now 15 people but he has authority to add up to 15 more workers making the total 30. If you look in the first pic I uploaded you will see how I have set it out, so where placeholder appears he wants to be able to add an employee and have it automatically add to the roster.
So in the roster I have a1=worker1 and in a2 =if(a1=worker1,worker2
and then a continuing nested if statement all the way up to 30, so that regardless of which employee he starts the roster from the next in line will automatically be added in.
Now the problem I'm having is at the moment we only have 15 employees listed, so when we get to the 15th employee he wants the roster to start again at 1 and not display "Place Holder" or a blank cell.
so the formula I have so far is simply nested if statements
=IF(F33=worker1,worker2,IF(F33=worker2,worker3,IF(F33=worker3,worker4,IF(F33=worker4,worker5,IF(F33=worker5,worker6,IF(F33=worker6,worker7,IF(F33=worker7,worker8,IF(F33=worker8,worker9,IF(F33=worker9,worker10,IF(F33=worker10,worker11,IF(F33=worker11,worker12,IF(F33=worker12,worker13,IF(F33=worker13,worker14,IF(F33=worker14,worker15,IF(F33=worker15,worker16,IF(F33=worker16,worker17,IF(F33=worker17,worker18,IF(F33=worker18,worker19,IF(F33=worker19,worker20,IF(F33=worker20,worker21IF(F33=worker21,worker22,IF(F33=worker22,worker23,IF(F33=worker23,worker24,IF(F33=worker24,worker25,IF(F33=worker25,worker26,IF(F33=worker26,worker27,IF(F33=worker27,worker28,IF(F33=worker28,worker29,IF(F33=worker29,worker30)))))))))))))))))))))))))))))
now the way I have it set if he wants to start at worker15 the next one to show up is "Place Holder" what I want is for it to recognize that if place holder comes up revert to worker1
Ive tried and statements etc but I'm brick walling.
