Forum Discussion

  • mtarler's avatar
    mtarler
    Silver Contributor

    JOGINDER SINGH It isn't "pretty" but I believe this does what you need:

    =LET(Data,A6:B12, mains, J6:L6, Flavours, I7:I14,
    _m, TAKE(Data,,1), _s, TAKE(Data,,2),
    MAKEARRAY(ROWS(Flavours),COLUMNS(mains),LAMBDA(r,c,SUM(IFERROR(--(TEXTBEFORE(TEXTSPLIT(","&TEXTJOIN(",",1,FILTER(_s,_m=INDEX(mains,c),"")),INDEX(Flavours,r)&"/",,1,1,""),",",,1,1,"")),0)))))
    • JOGINDER SINGH's avatar
      JOGINDER SINGH
      Copper Contributor
      Thanks for giving your valuable time, But can you tell me that in which cell address this function to be apply?
      • clynn8452's avatar
        clynn8452
        Copper Contributor

        JOGINDER SINGH Hello. i need to extract data from and excel spreadsheet to fill out a form that i can customize.  i used to do this years ago but cannot recall how i did it.  i remember being able to set up the title fields of the date where i wanted them to go on the form.  i also need to be able to print the forms.

Resources