sort numbers in EXCEL?
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 |
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 |
All times are GMT +1. The time now is 12:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com