Is there a weighted random number excel formula that excludes other numbers? [closed]

I have an excel formula that generates various weighted random numbers in column A, using INDEX, MATCH and RAND. However, I'm trying to create another column with weighted random numbers that exclude the numbers from column A. Does anyone know how to do this?