Thread: Randomizing
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
James Silverton[_3_] James Silverton[_3_] is offline
external usenet poster
 
Posts: 119
Default Randomizing

Hello All!

I have been using a sort on a helper column of random numbers [generated
by RAND() ] to randomize a data set but I notice that the column of
random numbers changes when I do the sort. Can any expert tell me if the
sort or the recalculation occurs first?

--


James Silverton
Potomac, Maryland

Email, with obvious alterations:
not.jim.silverton.at.verizon.not