Forum Discussion
JOGINDER SINGH
Feb 03, 2023Copper Contributor
Filling a form with excel function
Hello everyone.
I need help of your's. Can you Please?
I have attached an excel sheet for your reference. So please open that and help to resolve my problem mentioned therein
- mtarlerSilver 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 SINGHCopper ContributorThanks for giving your valuable time, But can you tell me that in which cell address this function to be apply?
- clynn8452Copper 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.