Can Microsoft Excel randomize orders of items in a list?

MicrosoftExcel

1 answer

Answer

1108297

2026-03-25 18:10

+ Follow

Just use =RAND() to generate random numbers in your list. Then you can sort it with the random numbers.

Comments on answer:

Let's just say the list is in column C and has 12 entries. Your answer says to "just use =RAND() to generate random numbers in your list". OK, so where "in the list" would I put the =RAND() function command? And in which cells would that function display the "random numbers in my list" that you suggest?

And then, how would I go about sorting "it" with the random numbers that somewhere have been generated?

Sorry for being the devil's advocate, but I just want to get clear info on how to do the task you answered.

ReportLike(0ShareFavorite

Copyright © 2026 eLLeNow.com All Rights Reserved.