Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
With a helper column.
Put the =RAND() function in the helper cells on the same row as your values and sort using that as the criteria. When done, delete the helper cells. "Alex" wrote in message ... Hi, I have a column with 50 numbers and I want to sort them in a random order. I had these number generated using =rand() but, I accidentaly put them in ascending order. So, now I want to put them in a random order, it doesn't need to be like before, just random. Is this even possible?? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
I have a set of numbers in an excel spreadsheet and want to find t | Excel Discussion (Misc queries) | |||
Excel Adding duplicated numbers together | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Excel 2003 "File Open": how keep folders at top with sort by Date. | Excel Discussion (Misc queries) |