Ask Your Question
0

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 +0100

Glen 20 gravatar image

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

Alex Kemp gravatar image
edit retag flag offensive close merge delete

Comments

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 +0100 )edit

2 Answers

Sort by » oldest newest most voted
3

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

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

Comments

2

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

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

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

@glen,

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

Stats

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

Seen: 111 times

Last updated: Aug 27 '19