Looking to do a random sort of records in an excel file

  • Thread starter Thread starter jenystr
  • Start date Start date
J

jenystr

I have an excel file with records in it. At any given time I can hav
any number of records in the file. I would like to do a random sort o
those records putting the results in another sheet within the sam
excel spreadsheet. It would be nice if the output had a column wit
the ranking of each record in it.

It can't be anything too complicated or something I have to change eac
time I want to do a different group of records. There can be as man
as 200 and as few as 5 records in a file
 
jenstyr
You could put =RAND() in a helper column and then sort on the random numbers

If your data is in column A then

=RANK(A1,A:A

will give you the ranking of the number in A1. It won't matter if this formula gets sorted or not

Good Luck
Mark Graesse
(e-mail address removed)

----- jenystr > wrote: ----

I have an excel file with records in it. At any given time I can hav
any number of records in the file. I would like to do a random sort o
those records putting the results in another sheet within the sam
excel spreadsheet. It would be nice if the output had a column wit
the ranking of each record in it

It can't be anything too complicated or something I have to change eac
time I want to do a different group of records. There can be as man
as 200 and as few as 5 records in a file
 
Back
Top