Entering lists

Hi,

I need a formula or program that can take the cells in a selection and create every possible order they can go in. For example, if I list in row A the names Dave, Bob, Simon, Mark I need in the rows following every possible combination of them rows to be entered. I.e

Row A: Dave Bob Simon Mark
Row B: Bob Dave Simon Mark
Row C: Simon Bob Dave Mark

etc..

Any help would be great.

Thanks,

Phil

Thanks,that does work...but if I need a formula as sometimes I will have more names. Is there anyway of doing what you did automatically?

Thanks,

Phil

Thanks for your help but unfortunately that doesn't work. The order of the 4th and 5th people in relation to each other never changes. I.e whatever is in column 4 is always ahead of 5 by one place. I'm sure there must be a way of doing this but it is going to be very complicated!

Thanks again, any more help would be greatly appreciated!