Excel equation

Copper Contributor

hey guys so I created an equation =INDEX(SORTBY(AI3:AI15, RANDARRAY(ROWS(AI3:AI15))), SEQUENCE(AJ3)) but when it spill the data it spills it in consecutive cells I wanted to have it spilled in specific cells  please help 

 
 

 

 
 

 

 

 

0 Replies