Ask Your Question

Can someone help me learn how to create all combinations in the pic, there should be 64 sentences. thank you

asked 2019-08-27 13:05:51 +0200

Glen 20 gravatar image

updated 2020-08-09 11:58:37 +0200

Alex Kemp gravatar image
edit retag flag offensive close merge delete


It does not matter if you pay more attention at school. ;-) You can do it, if you strain your brain. I wish you success.

ebot gravatar imageebot ( 2019-08-27 13:13:34 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2019-08-27 15:49:59 +0200

Ok, while I support @ebot's comment, seeing there's already a solution posted, I'll re-post this formula to be put into D1 and drag-copied to D64:

=TEXTJOIN(" ";0;OFFSET($A$1;MOD(QUOTIENT(ROW()-1;4^0);4);0);OFFSET($A$1;MOD(QUOTIENT(ROW()-1;4^1);4);1);OFFSET($A$1;MOD(QUOTIENT(ROW()-1;4^2);4);2))
edit flag offensive delete link more



Next homework for students: Explain in detail, how this solution works ;-)

Opaque gravatar imageOpaque ( 2019-08-27 15:59:49 +0200 )edit

answered 2019-08-27 15:08:39 +0200




ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you. If the answer met your need, please click on the ball Descrição da imagem to the left of the answer, to finish the question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-08-27 13:05:51 +0200

Seen: 115 times

Last updated: Aug 27 '19