I attempting to create a formula that will create random numbers in a column without repeats. For example, I have a spreadsheet with two columns. The first column I want to contain the random numbers and the second column will contain names. I just need the formula to create the random numbers once. I'm sure this is probably fairly easy for some, but not me. Ugh! Thank you for your help.