Constrained Ordering in Excel

Question

I'm basically trying to use excel to solve a constrained optimization problem without any optimization.

Here's the problem: I have five people and five work stations. I want each person to visit each work station once with no repeats. There are a couple other constraints, such as "person 1 must visit an odd workstation first", etc, but these vary on a couple scenarios I'm trying to create. 

I've tried working with the solver on this, which I'm not that familiar with. I've create a 5x5 matrix, with each row representing a person and each column representing a shift of work. The number in each (row,column) would then be the work station a person is at at a given time, The basic constraints are:

-all values are integers

-all values are 1<=x<=5

-all rows satisfy alldifferent

-all columns satisfy alldifferent

-any other basic constrains we throw in

I've done this, and curiously the solver keeps throwing out solutions where the alldifferent constraints are not respected. Am I doing something illegal here?

Answer 1

Excel 2010 to 2019 Power Query (aka Get and Transform)

Oodles of random solutions.

No formulas, no Solver, no VBA macro.

Might also be of interest to Sudoku players.

http://www.mediafire.com/file/hl12w1r1ushna4n/03_19_19.xlsx/file

http://www.mediafire.com/file/zjdd8rkajrc9ac8/03_19_19.pdf/file

Answer 2

Edit:  Solver solution deleted due to lack of interest by poster.