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