Quote Originally Posted by tigeravatar View Post
Zuerner,

Welcome to the forum!
So if you have headers in row 1 and actual data starts in row 2, and the drop-down validation lists are in columns, A B and C, then in cell D2 and copied down you could have:
=MID(IF(A2="","",", "&A2)&IF(B2="","",", "&B2)&IF(C2="","",", "&C2),3,99)
Is something like that what you mean?
I think I haven't made myself clear. I have got various cells that is a staff rota, so in each cell I need to put in a number of names so for example 5 people will be on phone duty while another 4 might be doing the post. Each cell will have the dropdown in it so I can then just click and select the names that go into each cell. Hope you understand what I am trying to achieve.Many thanks Martin