Random Number generator

Hi, I have 200 stocks. I need to be able to rank them in a randomn order. I start off with stock 1 and use =randbetween(1,200). This will give a randomn number. I then need to be able to generate another randomn number for Stock 2, excluding the Number already generated for Stock 1. For Stock 3 I need to be able to generate another number however excluding Stock 1 and Stock 2 and so on.