The values in column B should match what was in column A before, but as you paste them, the values in column A will change. That's expected since the RAND() formula recalculates a new random number each time you do anything else in the spreadsheet. Copying the values only (not the formula) over to column B will prevent them from changing in future.

Talk Doctor Online in Bissoy App