/r/excel wrote a formula. Idk how to read nor implement it

%3CLINGO-SUB%20id%3D%22lingo-sub-3038781%22%20slang%3D%22en-US%22%3E%2Fr%2Fexcel%20wrote%20a%20formula.%20Idk%20how%20to%20read%20nor%20implement%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3038781%22%20slang%3D%22en-US%22%3E%3CP%3ETo%20automate%20anki%20flashcard%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20a%20list%20of%20image%20file%20names%20in%201%20column.%3C%2FP%3E%3CP%3EI%20will%20enter%20captions%20for%20each%20image%20file%2C%20but%20some%20have%20multiple%20images%20%26amp%3B%20no%20captions.%3CBR%20%2F%3E1%20row%20exported%20%3D%201%20flashcard.%3CBR%20%2F%3EFilenames%20to%20go%20in%20Image%20columns%3C%2FP%3E%3CP%3Ee.g.%203%20images%20no%20captions%2C%204th%20image%20has%20caption.%20Formula%20for%3A%20if%20caption%20in%20a%20row%2C%20Fill%20image%20names%20up%20to%20the%20image3%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKeep%20pulling%20from%20list%20until%20exhausted%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%22100%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2212.5%25%22%3EImage%20List%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3EImage%201%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3ECaption%201%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3EImg2%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3ECap2%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3EImg3%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3ECap3%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3Eetc%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2212.5%25%22%3E001.png%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2212.5%25%22%3E002.png%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2212.5%25%22%3Eetc%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2212.5%25%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20answer%3A%26nbsp%3B%3CBR%20%2F%3E%3DLET(a%2C%24C%241%3A%24Z%2412%2Cb%2CINDEX(a%2C1%2C)%2Cc%2CCOLUMN(B1)%2Cd%2CCOLUMNS(a)%2F2%2Ce%2CSEQUENCE(d%2C%2C%2C2)%2Cf%2CINDEX(a%2Cc%2Ce)%2Cg%2CINDEX(a%2Cc%2Ce%2B1)%2Ch%2CLEN(g)%26gt%3B2%2Ci%2CIF(OR(h)%2Cf%2C%22%22)%2Ci)%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%22%3CSPAN%3Efilled%20to%20the%20right.%20To%20see%20how%20it%20works%20replace%20the%20last%20name%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Ei%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bwith%20earlier%20names.%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%5E%20what%20is%20the%20meaning%2C%20earlier%20names%3F..%3CBR%20%2F%3Ewhich%20cell%20do%20I%20put%20formula%20in%3CBR%20%2F%3Ewhat%20is%20the%20error%20it's%20throwing%3F%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESrry%20would%20upload%20a%20template%20but%20there's%20no%20option%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3038781%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

To automate anki flashcard 

Have a list of image file names in 1 column.

I will enter captions for each image file, but some have multiple images & no captions.
1 row exported = 1 flashcard.
Filenames to go in Image columns

e.g. 3 images no captions, 4th image has caption. Formula for: if caption in a row, Fill image names up to the image3 column.

 

Keep pulling from list until exhausted

 

Image ListImage 1Caption 1Img2Cap2Img3Cap3etc
001.png       
002.png       
etc       
        
        

 

the answer: 
=LET(a,$C$1:$Z$12,b,INDEX(a,1,),c,COLUMN(B1),d,COLUMNS(a)/2,e,SEQUENCE(d,,,2),f,INDEX(a,c,e),g,INDEX(a,c,e+1),h,LEN(g)>2,i,IF(OR(h),f,""),i) 

"filled to the right. To see how it works replace the last name i with earlier names."

 

^ what is the meaning, earlier names?..
which cell do I put formula in
what is the error it's throwing? 

 

Srry would upload a template but there's no option?  

0 Replies