Forum Discussion
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...
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.