Array formula not working in Google Sheets

Hi.

I got some help a little while back with this formula

Please Login or Register  to view this content.

Which worked perfectly. Problem is I now need it in Google Sheets as its from responses from a Google Form questionnaire. When I try and copy it or open the spreadsheet in sheets the code changes and stops working.

Please Login or Register  to view this content.

Any ideas?

Neil

So, if you change it to

Please Login or Register  to view this content.

is not working?

Hi Paul

I don’t change it. When I copy the formula or open the spreadsheet in google sheets it changes it automatically and the doesn’t work. Any thoughts?

Neil

Any thoughts?