Creating an random price order book

Hello,


I am new to excel and I am trying to create a simple simulation for work. Essentially it's an order book. I have a working model, but I need it to be more robust. I will break apart where my model needs flexibility.



Here is the how the simulation is supposed to work: Any random even amount of people input random order prices between two bounds which I choose (in this case 400 and 500). Then their orders are randomly placed into the buy side or sell side (should be an equal amount on both sides). Buy side (blue color) is ordered greatest to least and sell side is ordered least to greatest. The cell K22 records the average price between where the two sides meet. I would like that to be tracked some how for each simulation.


The first column B needs needs to be a random even length. Right now I just have the list dragged down 26 lines.

Column C, D, and E are my attempt at randomizing and ordering a list. Feel free to change the logic.


Lastly I have no way of recording what the last simulation produced for results.



Appreciate the help.

Wow this was beautifully done. Elegant. Jealous.