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

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