Forum Discussion
leanne8
Jul 09, 2020Copper Contributor
School Presentation Day Data: Help save me endless hours of typing
I recently started working in a school and I'm finding our processes are a little dated. Presentation day prep for end of year is so huge and I spent days typing everything out last year, we need a b...
Subodh_Tiwari_sktneer
Jul 12, 2020Silver Contributor
You may also add predefined text in the formula suggested by SergeiBaklan like this...
Assuming your data looks like this on Sheet1...
Then on Sheet2, you may have a list of all the students names in column A starting from cell A1 and place this formula in B1 and confirm it with Ctrl+Shift+Enter.
=TEXTJOIN(CHAR(10),TRUE,IF(INDEX(Sheet1!$C$2:$K$5,MATCH(A1,Sheet1!$A$2:$A$5,0),)=1,"Academic Achievement " &Sheet1!$C$1:$K$1,""))
And the formula output would be like this...
Please refer to the attached for more details.