jeudi 14 novembre 2019

Ramdomize selected column in Excel

I am new to this formula stuffs in excel. After searched on the internet I found this =RAND() function which I am using to randomize a couple of numbers. Like the one on the image.

By default, pressing Ctrl D or F9 is randomizing all the numbers in the worksheet.

Is it possible to select a group of cells and randomize only those and not changing the other columns?

enter image description here




Aucun commentaire:

Enregistrer un commentaire