Hi all,
I hope I'm defining what I want correctly, but basically I would like to know how can I create a text matrix using Excel, that will multiply text in a specific area, like I've attached in the image.
Is this possible?
Thanks in advance
Matrix.JPG
Can you post it in excel?
scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
Sure, didn't know this was an option.
We're in excel forum ..that's the whole pointOriginally Posted by galitg
Not the most elegant solution, using 3 helpers:
J5 and down
=IF(SUM(COUNTIF(J4,$J$4:J4))< COUNT($C$4:$C$7)*COUNTA($D$4:$D$7),J4,INDEX($B$4:$B$7,MATCH(J4,$B$4:$B$7,0)+1))
K5 and down:
=INDEX($C$4:$C$7,ROUNDUP(MOD(((COUNTA($K$4:K4)+1)/COUNTA($C$4:$C$7))-0.1,COUNTA($C$4:$C$7)),0))
L5:
=INDEX($D$4:$D$7,ROUNDUP(MOD(((COUNTA($L$4:L4)+1)/COUNTA($D$4:$D$7))-0.1,COUNTA($D$4:$D$7)),0))
and the combination in column H4 and down:
=I4&"_"&J4&"_"&K4
Last edited by Limor_OP; 10-13-2020 at 07:12 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks