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

edit retag 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.

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

Sort by » oldest newest most voted

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))

more

2

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

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

C:\fakepath\206257_en.ods

-----------------------------------------------------------------------------

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 to the left of the answer, to finish the question.

more