Feb 03 2023 09:36 AM
Hello everyone.
Feb 03 2023 12:53 PM
@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)))))
Feb 04 2023 09:14 AM
Feb 04 2023 01:55 PM
Feb 05 2023 09:30 AM
Feb 05 2023 10:55 AM
Feb 05 2023 03:33 PM - edited Feb 05 2023 03:34 PM
Feb 05 2023 07:54 PM
@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.