Excel equation

%3CLINGO-SUB%20id%3D%22lingo-sub-1921038%22%20slang%3D%22en-US%22%3EExcel%20equation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1921038%22%20slang%3D%22en-US%22%3E%3CP%3Ehey%20guys%20so%20I%20created%20an%20equation%26nbsp%3B%3CSPAN%3E%3DINDEX(SORTBY(%3C%2FSPAN%3E%3CSPAN%3EAI3%3AAI15%3C%2FSPAN%3E%3CSPAN%3E%2C%20RANDARRAY(ROWS(%3C%2FSPAN%3E%3CSPAN%3EAI3%3AAI15%3C%2FSPAN%3E%3CSPAN%3E)))%2C%20SEQUENCE(%3C%2FSPAN%3E%3CSPAN%3EAJ3%3C%2FSPAN%3E%3CSPAN%3E))%20but%20when%20it%20spill%20the%20data%20it%20spills%20it%20in%20consecutive%26nbsp%3Bcells%20I%26nbsp%3Bwanted%20to%20have%20it%20spilled%20in%20specific%20cells%26nbsp%3B%3C%2FSPAN%3E%26nbsp%3Bplease%20help%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1921038%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EHow-to%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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