excel - Randomize the order of rows -


i creating quiz in excel. structure is:

 serial no.  question    select right option      right/wrong      marks 

i have list of questions , options answers in dropdown list. want randomize questions answer options [means want randomize whole row].

is there build in excel function?

you might achieve adequate result addition of column containing `=randbetween(x,y) , sorting entire rows on column. here x lowest serial no. , y highest. can changed f9.

not random because of inherent (minor) deficiencies how randbetween works , since capable of producing duplicate values tend favour status quo.


Comments