Is there a simple way to rearrange a row of cells randomly (without repetition) using a formula preferably? and without sorting, filtering etc.
Basically what i need a formula to do something like this:
My sample data:
Thanks.
I have Excel 2016.
Basically what i need a formula to do something like this:
My sample data:
VBA Code:
DATA RANDOMIZED
1 2 3 4 -----> 2 4 3 1
5 6 7 8 -----> 6 5 8 7
Thanks.
I have Excel 2016.