Random numbers,in order no repats

[Gee monie]

I would like 3 random whole (range)numbers in a cell. The wizard offered me a little insight.

I would like these 3 numbers not to repeat and order numerically.


So 47,77,23 would be 23 47 77

22 33 22 would never happen(repeat)

Thoughts on a formula?

[HansDouwe]

Please try

Please Login or Register  to view this content.

[sandy666]

test this one (Power Query)

to generate new set just Data tab - Refresh All